Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
I need to create a calculated measure that changes based on the month and year slicer.
Currently my YTD measure is TrafficYTD = CALCULATE([Traffic],DATESYTD(DimDate[Date]))
However this doesn't work with the month changes.
My Year slicer is set to be 'is less than' and Month slicer is 'is between' and I was asked to NOT change the slicer setting.
Seeking solutions on this and please let me know if any addtional informaton is needed.
@Alex_369 DATESYTD to always take the data from Jan, so even if you have selected a different month range, you will get full-year data, what you are trying to achieve is not YTD, it is more of selected period, maybe change your measure to this:
Currently my YTD measure is TrafficYTD = CALCULATE([Traffic],ALLSELECTED (DimDate))
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you!
After I make it allselected, I have that period from each year calculated. How can I make it only calculate the selected year and make it dynamically changed with the year selected? My Year slicer is set to be 'is less than or equal to'. Thank you very much!