Microsoft Power BI DAX from Scratch
- Description
- Curriculum
- FAQ
- Reviews
If you are someone dealing with reporting, with the help of DAX functions you can unlock the advanced power of reporting in Power BI. These functions will help you get better data insights.
DAX or Data Analysis Expression is a library of functions and operators, using which you can create formulas and expressions. This will help you with creating powerful formulas to ease your data analysis and reporting process.
This course is designed in a Problem Statement – Solution format where we start with the problem to which a solution is sought with the help of DAX functions where each component of the expression is clearly explained in easy-to-understand terms,
What is in store for you?
In this course, you will
1. Understand the concept of DAX and how to create calculate column, measure, tables, and quick measures
2. From the exhaustive list of DAX functions, we will be looking into the most frequently used functions from the family of
- Date and Time function – WEEKDAY, EDATE, EOMONTH, DATEDIFF, TODAY, NOW
- Text function – FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT
- Logical function – IF, Nested IF, AND, OR, SWITCH
- Relationship function – RELATED, CROSSFILTER, RELATEDTABLE
- X-function – SUMX, RANKX
- Filter function – CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE
- Statistical function – DISTINCTCOUNT
- Time intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR
- Information function- CONTAINS
- Table manipulation function- SUMMARIZECOLUMNS
-
1
Getting StartedThis course teaches commonly used DAX functions for data analysis, enabling users to unleash the capabilities of Power Pivot, Power Query, and Power BI. Participants must have Power BI Desktop installed and be familiar with its interface, as well as have knowledge of creating data models and relationships between tables. The course provides all the necessary understanding to create DAX formulas, along with hands-on experience using provided datasets.
-
2
Syntax
-
3
Intro to DAX
-
22
X FUNCTIONS
This lecture discusses the concept of X functions in DAX, which require two arguments (a table and an expression). It provides a comparison between the SUM and SUMX functions, demonstrating how the latter function filters columns for calculations on a row-by-row basis. The section includes a demo on how to use SUMX with related tables to filter column data for more accurate calculations.
-
23
Knowledge check
