Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
Being new to DAX, I am stuck and would appreciate some help. My data table has many columns of which one is the Financial Year. I would like the user to select any financial year in a slicer and would then display the data for the selected year as well as the previous year. I made two measures, SelectedFY and PreviousFY. I wanted to use these measures to filter the data, but it only works when I hardcode the variables.
So this works:
Solved! Go to Solution.
@WillemvB - try this solution and let me know if this resolve your problem. attached pbix file
If my post helps you to find solution would be happy if you could mark my post as a solution and give it a thumbs up
Best regards
Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/
Thank you, Manoj. This solution helps me.
@WillemvB - try this solution and let me know if this resolve your problem. attached pbix file
If my post helps you to find solution would be happy if you could mark my post as a solution and give it a thumbs up
Best regards
Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |