subtraction value of a day and previous day

[akarca]

Hello,

I would like to subtract the values of the day with the previous day value. Tabel like as fallow;

Date                  Value

01.01.2022       1259

02.01.2022       1301

03.01.2022       1238

etc..                  etc...

[v-yangliu-msft]

Hi  @akarca ,

Here are the steps you can follow：

1. Create calculated column.

Column =
SUMX(FILTER(ALL('Table'),
'Table'[Date]=EARLIER('Table'[Date])-1),[Value])
-
[Value]

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[PowerUserR · Accepted solution]

Hi,
You can use this logic to retrieve the previous day value and then substract from there: https://datacornering.com/calculate-last-or-previous-value-within-power-bi/