DAX

DAX Tutorials – Learn DAX For Free on UdemyTuts.com – Free Udemy Courses Website

DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.

It’s easy to create a new Power BI Desktop file and import some data into it. You can even create reports that show valuable insights without using any DAX formulas at all. But, what if you need to analyze growth percentage across product categories and for different date ranges? Or, you need to calculate year-over-year growth compared to market trends? DAX formulas provide this capability and many other important capabilities as well. Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line. This is the power of Power BI, and DAX will help you get there.

Topics Include:

• Syntax
• Row Context
• Filter Context
• Calculated Column
• Measure
• Implicit Filter
• Explicit Filter
• Iterators
• Evaluation Context
• SUM function
• SUMX function
• AVERAGEX function
• CONCATENATEX function
• FILTER function,
• CALCULATE function
• RELATED function
• RELATED TABLE function etc.