Defaulting an Intelligence Sheet to the max date in Dim_Date on open

Started by Ji Woo Park · 5 days, 13 hours ago · 0 replies · 17 views
Ji Woo Park Participant
5 days, 13 hours ago

I've got a sales report built on a semantic model with a proper Dim_Date table. What I want is for the report to land on the latest available date automatically when someone opens it, driven by the max date in Dim_Date, so it moves forward on its own as new data comes in. The date slicer should still let people go back and pick any earlier date when they need to. How to handle the default-to-latest part in the Intelligence Sheet?

About this topic

  • Replies 0
  • Views 17
  • Participants 1
Fabric Plan
Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON