Category: DAX

Enterprise DNA Learning Summit August 2019 – Final Day Wrap Up

We have reached the end of this quarter’s Learning Summit! What a fantastic event it has been. Thank you to all those who attended any session or have watched any of the replays. Always appreciate the feedback that comes in. Just to wrap up for the summit, I thought I would review some of the

Continue reading

What You Will Learn During The Next Enterprise DNA Learning Summit – August 2019

Enterprise DNA Learning Summit, November 2018 - Registrations Open & Content Announcements

The next learning summit is not far away and the response from those connected to Enterprise DNA has been huge. We now have close to 1000 Power BI users registered for the event. There will be plenty of new and interesting content that will be covered during this summit. The best thing about it is

Continue reading

How To Allocate Results To Templates At Every Single Row Using Power BI

Allocating Results To Predetermine Table Templates Inside Of Power BI

Here I want to showcase a unique idea around allocating results to predetermine table templates inside of Power BI. Many of you who have been working with Power BI tables will know and understand that there’s not a huge amount of flexibility around what you can actually place into tables. So when you have a

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