Calculated column

Anonymous · ‎09-24-2021

Hey guys,
I wanna calculate a new column with the following formula "column A - column B + column C" but the problem is that I can only get the value right for the first row.
how can I write a DAX function that would get the value of last index " e.g. in excel I would write ="NewColumn"2+[@C] and so on"
thanks !

Greg_Deckler · ‎09-24-2021

@Anonymous I don't understand what you are trying to do, are you trying to take the value of C from the previous row? If so, that is likely not going to work as that essentially requires recursion.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎09-24-2021

@Greg_Deckler

well yeah that's basically what I'm trying to do, so recursion functions are not possible in power BI?
e.g. @C2 the value should be "1790930,93-1631244,46 + 2540804,2"

Greg_Deckler · ‎09-24-2021

@Anonymous Not really. Previous Value aka "Recursion" - Microsoft Power BI Community

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...