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,
I am new to PowerBI DAX and I working on chart for comparing YTD and prevoius year YTD, however, I am not able to create previous YTD measure as it shows just one single value in Card but I am not able to make it work with chart.
Here are my measures for YTD and previous Year YTD.
YTD = TOTALYTD([Total Sales], 'Date'[Date])
Hi @Radhe try
Previous YTD=
Did I answer your question? Kudos appreciated / accept solution!
Proud to be a Super User!
Hi @some_bih ,
The formula you gave did not work. The previous YTD over years is empty in table over the years but I can see one value in the card visual. I want the previous YTD to compare with YTD over the years. I have attached the Visual and settings. Hope this helps to understand my problem in more detail.
Let me know if you need more information.
The total sales itself is a measure.
Hi @Radhe as you already crrated YTD measure try
Previous YTD =
CALCULATE(
[YTD],
SAMEPERIODLASTYEAR('Date'[Date])
)
Proud to be a Super User!