Forum Discussion
Solved
Forecast future vacancies
Hello, Any ideas, how I would create a DAX to forecast future 'B4 - PO' vacancies based on historical data and variables, i.e. when a Pay Band = 'B3 - PSO' and Work Area = "PQiP" reaches their 'P...
Hi Lee_North ,
I think you can not solve it by DAX, but you can do it in the Power Query by M.
You can try this method.
I use this as my sample data:
And then transform data:
Here are the steps I did:
Final result is :
Is this what you would expect？
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
