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

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