Forum Discussion
Solved
Switch between two date options based on Filter
I have read many different versions of this question, this one here nearly gets what I want: https://community.powerbi.com/t5/Desktop/Filter-records-between-two-date-columns-with-one-slicer/m-p/82511...
Hi Sam7 ,
I updated my sample pbix file(see attachment), please check whether that is what you want.
1. Create a date type dimension table by Enter data method
2. Create a date dimension table and apply the date field on the slicer
Date = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))3. Update the formula of measure [qty] and [ssales]
Best Regards
I'll give this a go, thanks for your help.