Calculate % change between series of different date

[Dimitri70]

Hello everyone,

I'm facing some issue on Power Bi.

I'm trying to calculate the percentage of change betwen different series. Example 8/19 is my initial serie and I would like to compare the %change happened on 8/20 and then same on 8/21. Ideally, it would be good to compared only the serie I select example 8/21 vs 8/20 or 8/21 vs 8/19, if it is possible. Do you know how I can proceed?

[Aburar_123]

Hi @Dimitri70 ,

Please find the below approach,

I have a table like below

I have written the %diff measure like below

%diff =

var first_value=CALCULATE(SUM('Table'[Value]),'Table'[Date]=MIN('Table'[Date]))

var second_value = CALCULATE(SUM('Table'[Value]),'Table'[Date]=MAX('Table'[Date]))

return divide((first_value-second_value),first_value)*100

Thank you

[Dimitri70]

Hello Aburar_123,

thanks a lot for the proposal. It works when I put in the card, but I tried to put this in a matrix to see the change month by month between the different date extracted and it that case result show is always 0 

[Aburar_123 · Accepted solution]

Hi @Dimitri70 ,

Please do some changes as below,

Create a independent Date dimension table DATE_DIM and slicer dates should come from this table.

write the below measure and place it in the visual filter

IS_DATE_SELECTED = IF(MAX('Table'[Date]) in values(DATE_DIM[Date]),1,0)

Thanks you