topic Re: DAX, Calculation based on Previous row in DAX Commands and Tips

DAX, Calculation based on Previous row

arutsjak90 — Wed, 07 Jul 2021 17:48:22 GMT

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))

Re: DAX, Calculation based on Previous row

daxer-almighty — Tue, 06 Jul 2021 17:05:19 GMT

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.

Re: DAX, Calculation based on Previous row

arutsjak90 — Wed, 07 Jul 2021 17:49:13 GMT

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.

Re: DAX, Calculation based on Previous row

daxer-almighty — Wed, 07 Jul 2021 19:13:50 GMT

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