Forum Discussion

NBU_FFF's avatar
NBU_FFF
Helper I
1 year ago

Repeated Calculated Column Optimization

Dear community, I have a table need to add several calculation columns. Day0 = '1'[Qty]-'1'[Qty]/('1'[End_GroupQty_Previous]+'1'[VS_Qty])*'1'[Capacity] Day1 = VAR CurrentDate = '1'[MAV] VAR Curre...
DataNinja777's avatar
DataNinja777
Super User
1 year ago

Hi NBU_FFF ,

 

Apologies, my bad, DAX does not support true recursion, especially in calculated columns or tables where the value of a row depends on the value of a previous row in the same column. If you're trying to implement logic where each "DayN" calculation depends on the previous day’s result, DAX is not the right tool for this kind of recursion.

 

Best regards,

NBU_FFF's avatar
NBU_FFF
Helper I
1 year ago

DataNinja777  Thanks for your help again. I tried but showed error below:

 

Seemed DAX not support Recursive, not sure how you achieve that without error.

 

I attached my PBI file here, could you pls have a look?

sample_Dax.pbix

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi NBU_FFF,

     

    DAX doesn't support true recursion in calculated columns or tables because it lacks row-by-row iteration based on previous results. Since Power Query isn't an option either, the best approach would be to use a measure instead of calculated columns.

     

    Limitation: This won’t work for deep recursion across multiple rows because DAX measures rely on context, not row-by-row memory like Power Query.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


    Regards,
    Vinay Pabbu