Category: Time Intelligence

Enterprise DNA Learning Summit August 2019 – First Day Wrap Up

Enterprise DNA Learning Summit August 2019 Data Model Design Best Practices

What a great start to the Enterprise DNA Learning Summit. Today we had two sessions that dived into some beginner and intermediate development techniques that can be utilized inside of Power BI. We had a record number of live attendees of close to 350 which is a fantastic result. Every continent around the world was

Continue reading

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

Analyze Who Your Lost Customers Are Using Power BI & DAX

Use CALCULATE table function to determine the lost customers

In this example we’re going to dive into some customer churn analysis in Power BI. Power BI is an amazing tool for high-quality analytics. It does not have a close competitor at this point in time in my view. In this particular example, I’m going to show you how we can not only work out

Continue reading

Calculate A Reverse Cumulative Total In Power BI Using DAX

In this example, I will show you how you can create a reverse cumulative total inside of Power BI using DAX. This question came up recently on the Enterprise DNA Support Forum. You can view this forum post here –¬†Reverse Cumulative Sum A member had a unique requirement where they needed a cumulative total from

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