Help with Cumulative subtraction of same Category

[João_Santos]

Hi,

I need a Mesure / Calculated column that subtracts the value of D from column C if the column A are the same "ID",

Here is some example data:

A	B	C	D	Desired Result
450329855710	1006338572	68.640,00	29.702,40	38.937,60
450329855710	1006338578	68.640,00	5.548,40	33.389,20
450330356210	1006340576	930.252,50	94.000,00	836.252,50
450333739210	1006366169	39.969,00	13.323,00	26.646,00
450338367810	1006246225	18.600,00	3.100,00	15.500,00
450338367810	1006262553	18.600,00	2.170,00	13.330,00
450338367810	1006280307	18.600,00	2.170,00	11.160,00
450338367810	1006341340	18.600,00	2.170,00	8.990,00

The Excel function used was an IF statement: =IF(A2=A1;E1-D2;C2-D2)

[amitchandak · Accepted solution]

@João_Santos , try a new column like

[C] - sumx(filter(Table, [A] =earlier([A])  && [B] <= earlier([B]) ) , [D] )

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s

[João_Santos]

Hello!!

Exactly what i needed, thanks!