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.
PBIX file can be downloaded in the video description
Hope this article/video was helpful to you? Please leave your comments, suggestions, or questions in the comments.
Be the first to comment