Budget Allocation With Seasonality In Power BI

In this video, I will show you how to allocate a sales budget with monthly seasonality percentages into values by different timeframes using Power Query. Understanding how to use an allocation factor can be a huge help when distributing budget values across different time periods.

With the power of Power Query and Power BI, you can easily see the effect of seasonality on your budget and forecast. I will also show you how to create measures to show actual vs budget calculations for dynamic day level comparisons.  

 

watch?v=OAi6QFX-afE