Forecasting Same Period 2024 - YTD

Hi CuriousGuy001 ,

The Forecast measure is a very advanced piece of DAX code that would require a full article in itself. You can find detailed information on how to reallocate budgets at different levels of granularity in the video https://www.sqlbi.com/tv/budgeting-with-power-bi-pass-austria/.

In this article, the forecast measure is used, explaining how to calculate the next measure: the remaining forecast. You can modify it to suit your own data.
Showing actuals and forecasts in the same chart with Power BI - SQLBI

Also, if you have your own rules to predict the values, you can give me some example data and tell me its rules to better help you solve the problem. Here are some similar examples that I hope will help you.

Solved: Running Increase of Forecast based on Actuals - Microsoft Fabric Community

excel formula - How to calculate Projected YTD in Power BI using DAX - Stack Overflow

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.