Forum Discussion
Botturovic
8 years agoFrequent Visitor
Problem with "sameperiodlastyear" function
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