Category: Data Modeling

Implementing DAX Measure Groups Into Your Power BI Reports – Modeling Review

I want to touch on a really important topic within this tutorial. In many of the showcase demos that Enterprise DNA releases across webinars, summits, and to Enterprise DNA members you will see that the use of measure groups is extensive. There is a very good reason why measure groups have been implemented in all

Continue reading

Filter Your Data By Unique Financial Years & Quarters – Power BI Modeling Technique

Sometimes you want to filter your data by financial or fiscal years versus filter by calendar years. This particular tutorial is going to cover how you can do just that. What we’re going to do is use a current date table that we may already have inside of our model. If you want to learn

Continue reading

Fixing Incorrect Totals Using DAX Formula Techniques In Power BI

Getting totals correct inside your Power BI reports can sometimes be the most frustrating thing when utilizing DAX measures. The key to understanding how totals are calculated is to learn in-depth, how context works inside of Power BI. In this tutorial, I’ll go through several different examples of how to fix totals. By doing this,

Continue reading

Prevent YTD, QTD, MTD Results Extending Forward In Power BI

Recently I had a unique question pop up at the Enterprise DNA Support Forum. In this scenario, we are looking to evaluate YTD sales but we don’t want to evaluate anything past the last sale that may have occurred. We only want to show the cumulative YTD total up to the last sale. This is

Continue reading

Cumulative Totals Across Averages & Dynamic Date Logic – Advanced DAX

Today I wanted to cover a unique technique around cumulative totals inside of Power BI. Usually, when we are reviewing cumulative totals we are analyzing them over a date or over a month and year. What we are going to do here though, is we’re going to analyze them versus the month. This particular example

Continue reading