Forum Discussion
Creating projection from past data dynamically
Hi, I need to make a projection calculation and I'm a bit lost how to do that. I have actual data of the leaving employee count per month. I have the below chart with 3 measures: This...
I've created this measure based on your suggestion:
Future External Leaver projection = SUMX(FILTER(FILTER('Dim Date','Dim Date'[Date]>= TODAY()),[Num of Months in period]<=12),[Avg Leavers per period])
But unfortunately this measure is not showing up for future timepoints (that's the part I'm really clueless how to achieve!)