Forum Discussion
cwayne758
Helper IV
Helper IVCreate Previous Week Filter?
How would I go about creating a Previous Week filter in DAX? Pretty straightforward, trying to capture a snapshot of business only in the previous week of that Year. Below is the logic in...
If you need to have as a slicer different custom time periods you need to use "disconnected slicers" and measures for all time periods. Search in powerpivotpro.com as there are many articles about it like:
WorkHard
Helper V
Helper VFor the future reader, the date filter now has a "calendar week" option so it looks like this has been addressed.