topic Re: Forecast future vacancies in DAX Commands and Tips

Forecast future vacancies

Lee_North — Wed, 12 Oct 2022 11:12:24 GMT

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 'PQuiP Qualification Date' they'll become a 'Pay Band 4 - PO', so this would come off the total vacancies at that date?

Many thanks in advance for any replies and advice!

Lee

Re: Forecast future vacancies

Lee_North — Wed, 12 Oct 2022 11:13:45 GMT

Re: Forecast future vacancies

v-yinliw-msft — Thu, 13 Oct 2022 02:15:58 GMT

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.