Tag: advanced budgeting

Budgeting Performance Segmentation Using DAX In Power BI

Budgeting Performance Segmentation Using DAX In Power BI

When working on budgeting analysis inside of Power BI, there may be situations in your work where you want to segment the results into different groups, so that you can analyse which performers were better than others, versus their targets for example. This is some very unique analytics that can be done inside of Power

Continue reading

How To Calculate Actual Results To Budgets Per Product – Power BI & 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

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