Power BI Antipatterns #1: SWITCH(TRUE… in DAX (The Pilot)

Welcome to Power BI Antipatterns, my new blog post series! Over the past few years, as I’ve been working as an independent consultant, I’ve seen many examples of practices in Power BI that were less than optimal. In other words, they weren’t best practices. What’s curious is that sometimes very different people wrote code in the same (bad) way. So I thought I’d like to dissect some of the antipatterns, and I’m starting with the misuse of the SWITCH function in DAX.
Continue reading “Power BI Antipatterns #1: SWITCH(TRUE… in DAX (The Pilot)”

Microsoft Exam Ref DA-100 is now available!

Almost three years ago, my first book, Exam Ref 70-778, was published. Microsoft Exam 70-778 is now phased out, and Microsoft Exam DA-100 replaced it. The new official Power BI exam reference book, Exam Ref DA-100, is now available through Microsoft Press Store, Amazon, and other places! Continue reading “Microsoft Exam Ref DA-100 is now available!”

Single-letter day and month names in Power BI

Occasionally in Power BI, you may want to display day or month names as single letters to save space. This may result in duplicates because neither day nor month names are unique when you shorten them to one letter. In this blog post, I’m showing two solutions to the problem: one in DAX and one in Power Query (M language). Continue reading “Single-letter day and month names in Power BI”

Card drill through in Power BI

Drill through from cards is a common requirement in Power BI reports. While measure drill through has been possible for a while now, drill through from cards has been tricky until recently. In this blog post, I’m showing two ways to configure the card drill through. Continue reading “Card drill through in Power BI”

Understanding model recalculation in Power BI

Have you ever wondered why in Power BI calculated columns and calculated tables are called calculated and measures are not? That’s because in a certain sense, measures aren’t calculated, and calling them “calculated measures” is wrong. In this blog post, I’m discussing the implications of it–what recalculation in Power BI is, and how you can perform it. Continue reading “Understanding model recalculation in Power BI”