DAX Calculations Power BI Best Practices

In this tutorial, Id like to discuss my best practices for DAX Calculations. This is Part 3 of a video series that discusses some of the best practices Ive incorporated throughout the years of my Power BI learning journey. Ive consumed many resources which have been instrumental but has quickly become overwhelming. So I made my own notes that are easy to digest and hopefully these will be useful to others. Greg Note: Commenting section 2nd bullet point should read: If you have made assumptions in your code, you should also add explanatory comments Video Details 00:00 Introduction 02:05 DAX Editor Tips 03:42 Formatting 05:30 Commenting 06:11 Variables 07:19 Qualifications 07:55 CALCULATE 08:56 DATEADD 09:58 DIVIDE 10:35 SWITCH TRUE 11:27 Virtual Tables 12:52 USERELATIONSHIP 14:51 Measures, Calculated Columns 15:51 Measure branching 16:51 Context 18:03 Aggregation, Iteration Related Links Data Loading and Transformation Power BI Best Practices