Tag: Actuals vs Budgets

Sales Vs Budgets Insights – Extended Budget Allocation Formula

Actuals vs Budgets - Comparison Insights w/Power BI

In this tutorial, I’m going to show you an extended version of the ultimate Budget Allocation methodology that allows you to compare your Sales vs Budgets. The Budget Allocation formula allows you to solve data with mismatched granularities. For example, your Budgets could be at a monthly granularity while your Sales data could be at

Continue reading

Create Reports In Power BI To Show Deviations And Insights

In this tutorial, I want to show you how to set up compelling visualizations using deviations in your reports in Power BI. These are some really powerful insights that have historically been very difficult to complete and highlight in combination. I’m also going to look to highlight these specific deviations and what is causing the

Continue reading

A Power BI Training On Budgeting Scenarios Using DAX

So we’re going to really dive into some problem-solving in this Power BI training. This is some really great stuff that you can do with Power BI, but if we just step back for a moment, the key here is, first of all, you’ve got to be able to think analytically. And that’s what I

Continue reading

Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results using advanced DAX. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select?

Continue reading