Problem with "sameperiodlastyear" function

[Botturovic]

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

[v-yulgu-msft]

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