topic Re: Calculated column in DAX Commands and Tips

Calculated column

Anonymous — Fri, 24 Sep 2021 18:23:19 GMT

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 !

Re: Calculated column

Greg_Deckler — Fri, 24 Sep 2021 19:14:26 GMT

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.

Re: Calculated column

Anonymous — Fri, 24 Sep 2021 19:59:32 GMT

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"

Re: Calculated column

Greg_Deckler — Fri, 24 Sep 2021 20:19:57 GMT

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