Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Custom Rolling Date Range Filter for Report

Hi folks,

 

What is an effective way to build a fourteen day rolling date range in a Power BI report, especially when you need it to target a specific date? It needs to be something like the most recent Monday and fourteen days prior. I've found good examples online, which I can use to target the starting date and the end date of this range, but I haven't had any success using something equivalent to DATESBETWEEN or DATESINPERIOD to achieve this. Here's an example I've been working with targeting the most recent Saturday (based on another forum post I found):

 

Using DAX: 

 

Most Recent Saturday = TODAY() - WEEKDAY( TODAY() )
 
 
Rolling Two Week Filter = DATESBETWEEN('DateTable'[Date Column], [Most Recent Saturday], [Most Recent Saturday]-14)
 
Essentially, this would need to serve as a report-wide filter. Thank you!
 
pbrenneise

1 Reply