Do you think Microsoft’s own files always follow best practices? Think again! In this episode, I’m dissecting a calculated table DAX formula from a system file generated automatically in Power BI service. Continue reading “Power BI Antipatterns #3: Table functions”
Tag: antipatterns
Power BI Antipatterns #2: SELECTEDVALUE
The pilot issue of the Power BI Antipatterns series received good feedback, and I’m back with the second blog post in the series, in which I’m going to discuss the SELECTEDVALUE function. Continue reading “Power BI Antipatterns #2: SELECTEDVALUE”
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)”