Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Variable date range in variable

I have a number of pages in my Power BI report that display counts and sums of data from tables imported by a couple of different systems. I change the date range in the filters of each object to match the most recent week (used for meeting presentation).  Before the meeting I go into each object and set the new date range.  Since my pages combine various counts and sums for two different data sets, I can't simply set the date range on the page or the report. This seems like a great place to have a global variable for StartWeekDate and EndWeekDate. Change them once someplace and use the variable in my filters.  I understand that this is not possible but haven't been creative enough to figure out how to do something similar.  Is there a way in a measure using DAX to pull the start and end dates from a simple temp table where I can edit it each week?

1 Reply

  • Sounds like you should have a single date table in your model that has a relationship to the other tables.  You then apply the filter to the date table and it'll filter all tables.