Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i'm trying to compare sales of two different years by different categories.
I've created two measures: Total Amount YTD e Total Amount YTD last year.
When i try to insert the second measure "YTD Last Year" in the table Powerbi give me an error and i can't understand what's wrong.
Here is the formula of the measure:
If i try to insert the measure in a new table it works, but if i try to insert the category table it stops working.
So the problem must be somehow with the category table, but i don't have any problem with that table in the measure YTD
Any idea?
Thanks
Hi @Botturovic,
What is the error message under measure formula and the error message shown in visual?
Did you have a calendar table? I think you should refer to a date field from calendar table in SAMEPERIODLASTYEAR function.
Here are some similar examples for your reference:
SAMEPERIODLASTYEAR – comparison with previous year (DAX – Power Pivot, Power BI)
Get the YTD of same period last year using DAX
Regards,
Yuliana Gu