Forum Discussion

Lee_North's avatar
Lee_North
Frequent Visitor
4 years ago
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...
  • v-yinliw-msft's avatar
    v-yinliw-msft
    4 years ago

    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.

     

     

     

v-yinliw-msft's avatar
v-yinliw-msft
Icon for Community Support rankCommunity Support
4 years ago

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.