How to calculate relative references when need to refer previous value in same column

[AriFin]

How to calculate relative references in power query?

how I could calculate "sum" and "total" columns in power query when I need to refer previous value in same column?

in excel it is easy:

- sum column is =IF(B3=0,0,B3+C2) 

- total column is =IF(C4<C3,C3,0)

datetime	amount	sum	total
1.6.2018	100	100.00	0
2.6.2018	100	200.00	0
1.6.2019	100	300.00	300
2.6.2019	0	0.00	0
1.6.2020	100	100.00	0
2.6.2020	100	200.00	200
1.6.2021	0	0.00	0
2.6.2021	100	100.00	0
1.6.2022	100	200.00	200

[Ashish_Mathur]

Hi,

Given the first 2 columns as input, the SUM column can be obtained with a measure directly in your visual (using DAX instead of Power Query).  Will that work for you?