Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Lee_North
Frequent Visitor

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

 

Screenshot.png

 

Many thanks in advance for any replies and advice!

Lee

 

 

1 ACCEPTED SOLUTION
v-yinliw-msft
Community Support
Community Support

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:

vyinliwmsft_1-1665627029680.png

 

And then transform data:

vyinliwmsft_2-1665627050055.png

vyinliwmsft_3-1665627072805.png

vyinliwmsft_4-1665627105438.png

vyinliwmsft_6-1665627172683.png

vyinliwmsft_7-1665627187585.png

 

vyinliwmsft_8-1665627215040.png

Here are the steps I did:

vyinliwmsft_9-1665627238934.png

 

Final result is :

vyinliwmsft_10-1665627268376.png

 

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.

 

 

 

View solution in original post

2 REPLIES 2
v-yinliw-msft
Community Support
Community Support

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:

vyinliwmsft_1-1665627029680.png

 

And then transform data:

vyinliwmsft_2-1665627050055.png

vyinliwmsft_3-1665627072805.png

vyinliwmsft_4-1665627105438.png

vyinliwmsft_6-1665627172683.png

vyinliwmsft_7-1665627187585.png

 

vyinliwmsft_8-1665627215040.png

Here are the steps I did:

vyinliwmsft_9-1665627238934.png

 

Final result is :

vyinliwmsft_10-1665627268376.png

 

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.

 

 

 

Lee_North
Frequent Visitor

Power BI.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.