Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Slicer Used to Create Measures Based on Specific Date Comparisons

Hello, I am looking to have a slicer that determines the month of comparison in calculated measures. For example below, when selecting "2019 March" on the slicer, I'd like logically, to be able to calculate all other months against it, as the data to the right would suggest (I used constants for the example). I have attached my sample file in the link below.


Link to Sample File Capture.PNG



Community Support
Community Support

Hi , @Anonymous 

Sorry for that considering the security of your data, could  you  please share pbix files via onedrive for business?

Through your screenshot, I am still a little confused about the result you want.

It will be better  if  you  can explain  more about the logic .


Best Regards,
Community Support Team _ Eason


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.