Power BI Antipatterns #9: Filtering whole tables, part I

Whenever you can, you should avoid filtering whole tables in DAX–as opposed to columns–in DAX, because the performance may suffer, or you may get unexpected results, or both. In this blog post, we’re looking at the performance aspect. Continue reading “Power BI Antipatterns #9: Filtering whole tables, part I”

Power BI Antipatterns #8: Unformatted DAX

While unformatted DAX formulas may not affect the calculation speed, they can take a lot of time to read, and they can even hide errors just because the errors are hard to spot. Despite there being several ways to format your DAX code, I still see a lot of formulas that aren’t formatted. Continue reading “Power BI Antipatterns #8: Unformatted DAX”

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)”