Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.