Forum Discussion
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...
Hi AdamPBIDev,
AFAIK, current power bi data model tables do not include row and column index AND DAX expression does not support doing recursive calculations.
Previous Value (“Recursion”) in DAX - Microsoft Power BI Community
You can enter to query editor to do these calculations but it will be poor performance on recursive calculations.
Recursive Functions in Power BI / Power Query — The Power User
Regards,Xiaoxin Sheng
AdamPBIDev , Try a new column,
Value = MAXX(filter(Data, [Index] =0 && [Code] =EARLIER(Data[Code])),[Activity])* PRODUCTX(Filter(DATA, [Code] =EARLIER(Data[Code]) && [Index] <=EARLIER(Data[Index])), 1+[Activity Change %])
File attached after signature
Hi, amitchandak
I'm facing similar problem with recursive.
lets say i have an additional column called Cons. Also the formula is described bellow.
F2=C2*(D2 + Cons)
F3=D2*(F2 + Cons)
I've been struggling for that formula. would you like to give some advice. Thank you
