How to calculate the difference between two values in different years?

[matdub40]

I have a date table that contains these columns:

I use a "Euro Gross Amount" measure in a matrix on Power BI:

I would like to calculate the difference on the Euro Gross between the different years in percentage, I used this formula but it comes out as an "enexpected tuple" error :

DIFF% = DIVIDE(([Euro Gross Amount] - CALCULATE ([Euro Gross Amount], SAMEPERIODLASTYEAR('date'[date])), CALCULATE ([Euro Gross Amount], SAMEPERIODLASTYEAR('date'[date]), 0)

Where does my error come from? Is there a better way to calculate this difference?

[PC2790 · Accepted solution]

Try this:

DIFF =
DIVIDE (
    [Euro Gross Amount]
        - CALCULATE ( [Euro Gross Amount], SAMEPERIODLASTYEAR ( 'date'[date] ) ),
    CALCULATE ( [Euro Gross Amount], SAMEPERIODLASTYEAR ( 'date'[date] ) ),
    0
)

And convert this measure to a percentage in Measure Tools section

[matdub40]

Hello @PC2790 ,

Since this morning I have an error on my measurement "Evo%" which tells me

"MdxScript(Prod_WS_RCE_Order_SKU) (145, 44) Calculation error in measure 'dwh_d_order_sku'[Evo %]: The 'SAMEPERIODLASTYEAR' function expects a contiguous selection when the date column comes from a table on side 1 of a bidirectional relationship. "

Is this normal or should I change something?

[matdub40]

Thanks for your answer @PC2790 , it solved my problem!