Forum Discussion

danzrust's avatar
danzrust
Icon for Helper IV rankHelper IV
3 years ago

Date Filter with Overlapping Preselects (Today, Yesterday, Last 7 Days, Last 30 Days, Last Month...)

I am looking for hints on how to replicate these filter preselects in Power BI:       I want to to simply create this as a dropdown filter with no other extra steps for my users. Assume my ...
Need Help
Tips and Tricks
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

In your calculation item expression try using this instead

 

CALCULATE(SELECTEDMEASURE(), ALL('Calendar'), 'Calendar'[Last X Weeks] = "Current week")

 

Pat

 

danzrust's avatar
danzrust
Icon for Helper IV rankHelper IV
3 years ago

Hi Pat,
I've gone ahead and created standalone aggregated metrics so I could use them in the calculation groups. There are some other indirect benefits of having these agg metrics ready to go anyway 🙂

Thanks for your help!