An Introduction to Grouping Tables in Power BI: A Bridge Table Too Far

Grouping tables in Power BI is a powerful modeling technique that allows you to select from overlapping groups either in a slicer or across a matrix.
Totals at the Top of a Power BI Matrix Visual

You may want your Grand Total line to appear at the top of the Power BI Matrix. Achieving the effect involves a little bit of Power BI magic.
The Very Basics of Great Power BI Report Design

Some Power BI report design skills take years to master. These basic visualization concepts are easy to learn and they will make your reports far better.
Dynamic Rounding in Power Query: Easy Method

Dealing with estimated data often gives you numbers with more precision than you need or trust. Dynamic Rounding can create gains in performance.
How to Set Up a Data Assessment Framework in 12 Steps

Any successful data strategy is built upon a deep understanding of your data domain. To get there, you need to set up a data assessment framework first.
Dueling Current Rows: Shootout at the OKPI Corral

Walk through what happens when Current Row Filtering (Context Transitions) runs into two Current Rows that disagree with each other.
What to Expect When You’re Expecting a Power BI Implementation

The implementation of a tool is even more important than the tool you choose. These insights will help you be more prepared during a Power BI implementation.
Creating a Local ID in Power Query

In this video Brian Grant will walk you through just how easy these can be to create a Local ID in Power Query.
Combining Conflicting Customer Names Using Power Query

In this video Brian Grant will walk you through how you can leverage some more advanced features of the Power Query M language to combining conflicting customer names.
Time Is On Your Side: An Intro to DAX Time Intelligence

Basic aggregations are useful; but decision makers are going to want more and want it quickly. What they’re probably going to need next is time intelligence measures.
Detecting Overlapping Contracts with List.Dates() in Power BI

In this video I’m going to show you how to build an automated report which can surface these problems as quick as they show up. In the process you’ll learn about structured values and see the different ways grouping can wrestle down tricky data problems.
Grain Shifting Calculations in Power BI (The “Repeating Shipping Costs” Problem)

In this video I’m going to not only walk you through the surprisingly simple way this problem is solved, I’ll also walk you through how to understand the solution and even use DAX to visualize it on the page.