DAX basics in Power BI - Analysis (EN)

Popis kurzu

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.

Určeno pro

Obsah kurzu

• 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,…)

Předpoklady

Studijní materiály

Návaznosti