Hello!
In this session, we will look at a common budget allocation problem that involves seasonality. Seasonality has a major influence on many businesses. The ability to factor in seasonality in budgets and forecasts could help to create clear and meaningful comparisons with actuals.
Allocating a high level budget to lower levels of granularity, on the other hand, can be difficult. I'll demonstrate how to split seasonal budgets utilizing Power Query. This will allow us to compare the budget on a quarterly, monthly, and even daily basis. At the end, I'll demonstrate how to use dynamic DAX calculations for effective budget-to-actual comparisons.
PBIX file used in this sessio is available below 👇
Enjoy the session!
Fowmy Abdulmuttalib
Social Media / Website
https://youtube.com/c/excelfort
https://twitter.com/excelfort
https://linkedin.com/in/fowmy/
https://excelfort.com/blog/
watch?v=S2XvnKTWFbs
