Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Special holiday offer! You and a friend can attend FabCon with a BOGO code. Supplies are limited. Register now.

Fowmy
Super User
‎04-06-2022 10:34 AM

Budget Allocation With Seasonality In Power BI | Step By Step Tutorial

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.  

SUBSCRIBE AND WATCH THE VIDEO

 

 

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.