DAX (Data Analysis Expressions) is the formula language behind Power BI, Excel Power Pivot, and SSAS Tabular models. While it looks simple on the surface, DAX has some quirks—especially when it comes to evaluating conditional logic using the IF state...