Data Analysis Expressions (DAX) is the formula language of Power BI, Power Pivot, and SSAS (Tabular models). DAX is a functional language (executed code is contained inside a function). Learning DAX is much like discovering how to use formulas in Excel.
This course covers all the essentials functions/parameters that make DAX unique.
If you are learning DAX from scratch or already know the basics, this course will help you all to master the Power BI.
We'll first get started by learning the essential terms in DAX such as:
Implicit and Explicit Measure
Calculated fields
Evaluation Context
Table Relationship
Table Types and more
Next, we'll see DAX functions in action like, DISTINCTCOUNT, COUNTROWS, CALCULATE, DATESBETWEEN, DISTINCT, and more.
By the end of this course, you'll have the knowledge of:
How the DAX engine works
Using DAX to model and analyze your data
How to aggregate and filter with ease
The course is structured to minimize theory and focus more on action. The quick wins will keep you motivated to deep dive further