Even if you aren’t familiar with the term “DAX”, you’ve probably already been using it! DAX, or Data Analysis Expressions, is the library of functions and operators that are shared across Microsoft SQL Server Analysis Services, Power Pivot
Even if you aren’t familiar with the term “DAX”, you’ve probably already been using it! DAX, or Data Analysis Expressions, is the library of functions and operators that are shared across Microsoft SQL Server Analysis Services, Power Pivot in Excel, and Power BI Desktop. A good understanding of DAX can make report authoring more simple and more powerful, but as a functional language it’s often overwhelming for beginners.
On May 31, Paul Turley, Mentor for SolidQ and a Most Valuable Professional (MVP) for the Microsoft Data Platform, presented a Power BI Community Webinar on “Best DAX Practices From the Field”. During the 90 minute talk, Paul explored DAX language fundamentals and calculations, and gave some tips and tricks for using KPIs to get insights from your data.
If you’re just starting to learn DAX, check out Paul’s four recommended practices for new users below. You can also watch the presentation in i