Forum Discussion

AdamPBIDev's avatar
AdamPBIDev
Regular Visitor
4 years ago
Solved

Recursive Dax Calculation

Dear Dax Gurus,   Would appreciate some help - I'm looking to create a calculated column forecast which at index 0 simply takes the (Activity + (Activity * Activity Change %)), but for all other in...
regnig's avatar
regnig
Frequent Visitor
1 year ago

Can we used DAX instead of PQ? I use DAX table to build the data table which mean I cannot use PQ. here my lates Calculated Column.

 

Value2 =

Var init =
MAXX(
    filter(
        Sheet1,
        Sheet1[Date] = DATE(2025,1,2)
    ),
    [Activity] + Sheet1[Value]
)

Var o =
PRODUCTX(
    Filter(
        Sheet1,
        Sheet1[Date]  <= EARLIER(Sheet1[Date])
    ),
    (IF(
        Sheet1[Date] = MINX(Sheet1, Sheet1[Date]),
        init,
        1 + Sheet1[Value]
    ) * Sheet1[Percetage])
)

return o
 
but the result return (F2+F2*[Value])*[Percentage]. I expecting to get (F2+[Value])*[Percentage] actualy.

 

Thank you.
AntrikshSharma's avatar
AntrikshSharma
Community Champion
1 year ago

regnig no, while iteration, temporarily computed values of the previous rows aren't available in DAX and the calculation depends on the previous row during current row. You can import the table create in DAX by using PQ and then use the M code.