Forum Discussion
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 ...
In your calculation item expression try using this instead
CALCULATE(SELECTEDMEASURE(), ALL('Calendar'), 'Calendar'[Last X Weeks] = "Current week")
Pat
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!