Forum Discussion
How to create reference in power query when need to refer previous value in same column
how to create relative reference in power query when need to refer previous value in same column? in excel it is easy: - sum column is =IF(B3=0,0,100) - total column is =IF(C4<C3,C3,0) how to ...
v-juanli-msft
Community Support
Community SupportHi AriFin
"sum" and "total" columns are calculated column based on the condition you described in the example, right?
Best Regards
Maggie
Hi,
Sorry typo.
"sum" column cell (C4) = IF(B4=0,0,B4+C3). Calculating cululative sum between two zero
"total" column cell (D4) = IF(C5<C4,C4,0). Calculating total sum between two zero
Br. Ari