Forum Discussion
maxabele
5 years agoFrequent Visitor
Turnover Forecast
Hi guys, I searched the whole morning but couldn't find a solution to my problem. My goal is to forecast FTE development based on current FTEs + forecasted turnover rates for the future. I ha...
lbendlin
Super User
5 years agoPower Query has a List.Accumulate function that can do all that (and do all your dishes too)
https://docs.microsoft.com/en-us/powerquery-m/list-accumulate
If, however, you need to do that in DAX then you will have to resort to things like PRODUCTX() but they are less elegant and quite a bit slower.
If you want a sample solution then please provide sample data