Calculate the difference in change % between a currency value over a time period

[nnouchi]

Greetings,

I'm looking to calculate the % difference of change of a exchange rate between dates.

My table structure is the following:

Is it possible to calculate the % change between each row in a structure of this kind in Power BI?

I have tried this for one single column and have been unfortunately unable to figure this out. Here's my measure I created: 

DIVIDE(sum('Currency Rates'[Value.CAD]) - CALCULATE(Sum('Currency Rates'[Value.CAD]),PARALLELPERIOD('Currency Rates'[Dates],-1,MONTH)),SUM('Currency Rates'[Value.CAD]),-1)

Any help would be greatly appreciated.

Thanks,

Nic

[v-yulgu-msft · Accepted solution]

Hi @nnouchi,

Please try this measure:

% diff =
VAR currentmonthval =
    SUM ( 'Currency rates'[Value.CAD] )
VAR previousmonthval =
    CALCULATE (
        SUM ( 'Currency rates'[Value.CAD] ),
        FILTER (
            ALLSELECTED ( 'Currency rates'[Dates] ),
            MONTH ( 'Currency rates'[Dates] )
                = MONTH ( MAX ( 'Currency rates'[Dates] ) ) - 1
        )
    )
RETURN
    DIVIDE ( currentmonthval - previousmonthval, currentmonthval )

Best regards,

Yuliana Gu

[nnouchi]

Thank you, this is exactly what I was looking to accomplish.