topic Headcount Forecast - Recursive DAX Formula in DAX Commands and Tips

Headcount Forecast - Recursive DAX Formula

CatManKuhn — Fri, 21 Jul 2023 15:40:32 GMT

Hi all,

I am incredibly stuck and looking for assistance; I know Power BI doesn't have looping functionality at this time. I am trying to forecast headcount 24 months based on a 3 year average turnover rate. In order to do so, I reference the prior month's headcount and multiple by the 3 year average turnover rate. I then subtract this amount from the prior months headcount to get a forecasted headcount. I then do this same formula 24 times and use a final measure to combine all of these measures together so that I am not getting just one value for each month. A screenshot is provided below. I have limited this to 8 month forecast for simplicity purposes.

I apologize if this isn't clear - I am happy to help explain further! I am looking for any solution. It is okay if I have to do this outside of Power BI, but the challenge is that this formula is based off a DAX measure and I need this to work with various dimensions.

Thank you so much for your time!

Re: Headcount Forecast - Recursive DAX Formula

foodd — Fri, 21 Jul 2023 16:03:24 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Re: Headcount Forecast - Recursive DAX Formula

VaishnaviGandhi — Wed, 19 Jun 2024 16:17:01 GMT

Hi there, Did you get a solution for the above problem?

Thanks

Vaish