Forum Discussion
Previous Week
I have a report where I just look at the previous week. I had a pretty simple way to do this that worked fine until we hit a new year. I had simply used Week Number and then created these columns: ...
You should be able to use a veriation on my "Sequential" Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231
Anonymous
What about using dateadd formula to do this? I think it's better to use filter combination year and week number.
7daysago = DATEADD('date'[Date],-7,DAY)