topic Re: Calculate % change between series of different date in DAX Commands and Tips

Calculate % change between series of different date

Dimitri70 — Wed, 20 Aug 2025 01:31:57 GMT

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?

Re: Calculate % change between series of different date

Aburar_123 — Wed, 20 Aug 2025 02:15:07 GMT

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

Re: Calculate % change between series of different date

Dimitri70 — Wed, 20 Aug 2025 02:34:24 GMT

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

Re: Calculate % change between series of different date

Aburar_123 — Wed, 20 Aug 2025 05:33:09 GMT

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