Tag: Cumulative Projection Power BI

Showing Actual Results vs Targets Only To Last Sales Date In Power BI

Actual Vs Target To Last Sales Date Using DAX Cumulative Totals In Power BI

In this example, I want to show you how we can generate cumulative totals but only up to a certain point. A really relevant example if you are running some time comparison analysis and you’re looking at trends over time as a cumulative total in Power BI. Here’s a description of a specific scenario below.

Continue reading

How To Calculate A Cumulative Run Rate In Power BI Using DAX

How To Calculate A Cumulative Run Rate In Power BI Using DAX

With this tutorial, I want to showcase how you can calculate a cumulative run rate into the future based on some historical results. This was a requirement from the Enterprise DNA Support Forum where a member needed a forecast projection out into the future. Enabling them to compare current results to an average run rate over

Continue reading

Compare Multiple Metrics Cumulatively in Power BI using DAX

Comparing Actual vs Budget vs Last Year Results in Power BI w/DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results. 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? In this video

Continue reading