Forum Discussion
DAX, Calculation based on Previous row
Hi, I am trying to create column quite similar to what I have prepared in excel. It is based on 4columns. NewSubBalance = (for the minimum value in column Key) Requirements for the next rows as...
DAX is not Excel. Recursive calculations in DAX are often not possible. From your description it follows that you want a calculated column, not a measure. Use Power Query to perform this and similar calculations.
It is just an example to explain what I want to achive by calculated column. I am using Power BI, excel is as I said an example to illustrate calculation.
As I said, this type of caclulation should be (or even must be) performed in the source or in Power Query.