Forum Discussion

arutsjak90's avatar
arutsjak90
Icon for Helper I rankHelper I
5 years ago

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
EARLIER
daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

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.

arutsjak90's avatar
arutsjak90
Icon for Helper I rankHelper I
5 years ago

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.

  • daxer-almighty's avatar
    daxer-almighty
    Icon for Solution Sage rankSolution Sage
    5 years ago

    As I said, this type of caclulation should be (or even must be) performed in the source or in Power Query.