Forum Discussion
Dax Recursive Calculated Column
Looking for a bit of help with a recursive forecasting challenge. Effectively I'd like to create a calculated column which for the first index takes the Activity + ( Activity * Activity Change %...
AdamPBIDev , Try like
maxx(filter(Table, [Code] = earlier([Code])), [Activity]) * ProductX(filter(Table, [Code] = earlier([Code])), 1+[Activity Change %])
amitchandak Thanks for your suggestion!
Interestingly it returns the correct closing position forecast number but repeats the value each month rather than recalculating for each position - Screenshot attached
Any ideas?
Cheers
Adam