Tag: Cumulative Totals

Showing Cumulative Results vs Targets Only To Last Sales Date in Power BI

In this tutorial I demonstrate how to create a cumulative visualization in Power BI, showing cumulative results versus targets or budgets. This is a really good visualization to show things over time. You may watch the full video of this tutorial at the bottom of this blog. But, in this example, I only want to

Continue reading

Multiple What If Parameters In Power BI

Do you want to see how advanced you can get with Power BI? In this tutorial, I want to show you my favourite way to use Power BI. You can do some amazing work around scenario analysis by integrating what if parameters in Power BI — things like sales, profits, or transactions. You may watch

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

Creating Forward Forecasts in Power BI Using DAX

How to Create Forward Forecasts in Power BI Using DAX

In this blog, we’re going to go over how you can create automated forecast from historic data in Power BI. This is common in businesses to make forecasts and budgets. You may watch the full video of this tutorial at the bottom of this blog. Now, have you ever wanted to create automatic forecasts based

Continue reading