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