Forum Discussion

Botturovic's avatar
Botturovic
Frequent Visitor
8 years ago

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

1 Reply