Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

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 1
PaulOlding
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.