DAX, Calculation based on Previous row

[arutsjak90]

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 in formula below

if((CurrentCapacityHrs (earlier row) > NewSubBalance(earlier row)) then Requirements (current row) else Requirements (current row) + NewSubBalance(earlier row) - CurrentCapacityHrs(earlier row)) 

[daxer-almighty]

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]

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]

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