DAX basics in Power BI - Analysis (EN)

Description

Learn how to use Data Analysis Expressions (DAX) to solve a variety of basic calculations and to analyze data.

As you learn how to create effective DAX formulas, you can use your data more efficiently and begin to address real business issues that affect your overall business results.

Target

Contents

• DAX theory
• Syntax / concepts
• Counted columns vs measures
• DAX filters
• DAX sessions
• Contexts
• A few tips and tricks for DAX
• Practice with DAX in Power BI
• Creating a calendar
• COUNT, SUM, AVERAGE
• CALCULATE
• TIME Function (for analytics YoY, MoM, YTD%)
• CALCULATETABLE vs FILTER
• Table functions (UNION, ADDCOLUMNS, CROSSJOIN,…)

Prerequisites

Study Materials

Followups