Tag: Budgeting DAX

How To Calculate Actual Results To Budgets Per Product – Power BI & DAX

In this advanced video tutorial which is a breakout of a budgeting workshop that was part of the Enterprise DNA webinar series, I am going to run through how you can utilize some advanced functions inside of Power BI like CALCULATE, ALLSELECTED and SUMMARIZE. By using all the functions in combination we are able to

Continue reading

How To Create Budgets Which Have Seasonality Adjustments – Power BI Technique

We’re going to get advanced today around budgeting in Power BI. Occasionally, you will not actually have some unique budgeting or forecasting data and you need to create it. Most forecast or budgets will likely be created based on historical results in some way. You might do something very simple, like finding the results from

Continue reading

How To Calculate Budget Or Forecast Results Cumulatively In Power BI

Recently I ran an entire workshop as part of the Enterprise DNA webinar series on Advanced Budgeting Techniques. I know for a fact that there’s a huge requirement for this type of analysis in Power BI. Very often we have our actual results and we want to compare them to a forecast or a budget

Continue reading

Implement Budgets & Forecasts Automatically in Power BI Using DAX

I’m going to show you with this tutorial how you can create budgets in Power BI that are purely based of historical information and complete it in an automatic way. When you create budgets and forecasts sometimes you may have to go through a very comprehensive process. So this is obviously isn’t going to cover

Continue reading

Managing Seasonality in Budgeting Analysis – Advanced Power BI

Completing budgeting analysis in Power BI is unfortunately just not that easy. What I’m going to go through today is possibly the most advanced technique that you can get to with budgeting as we need to incorporate some seasonality into our budgeting numbers. I detail this quite extensively in the video tutorial, so there’s lots

Continue reading