Forum Discussion
ray_codex
Resolver II
Resolver IIFiltering previous workweek on a Power BI page
Hi, I had a request by a customer that needed a relative datefilter that filters the previous work week, monday to sunday. Working with a tabular model in AS I knew a failure in the refresh would...
Villezekeviking
Most Valuable Professional
Most Valuable ProfessionalYou can make use of my DAX Calendar that has offset-columns for days, weeks, months, quarters and years from today for any kind of relative date filtering!
Just filter your data on to ony include -1 on the Week offset from this calendar table after you've created a relationship and you're done.
As long as you refresh the dataset daily, the calendar table updates with it.
You'll find it here:
https://www.villezekeviking.com/dax-tables-calendar-and-time/