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 in formula below
if((CurrentCapacityHrs (earlier row) > NewSubBalance(earlier row)) then Requirements (current row) else Requirements (current row) + NewSubBalance(earlier row) - CurrentCapacityHrs(earlier row))
3 Replies
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.
