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.
Microsoft Power BI DAX from Scratch - A hands-on guide to Microsoft Power BI DAX
𝗘𝗡𝗥𝗢𝗟𝗟 𝗡𝗢𝗪 FOR THIS COURSE ON UDEMY
[ Ссылка ]
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.
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
Course content
Section 1: Introduction
Getting Started
Syntax
Intro to DAX
Section 2: DATE and TIME Function
WEEKDAY Function
EDATE Function
EOMONTH Function
DATEDIFF and TODAY Function
Section 3: TEXT Function
FORMAT Function
COMBINEVALUES Function
LEFT and FIND Function
Section 4: LOGICAL Function
IF Function
NESTEDIF Function
AND FUNCTION
OR Function
SWITCH Function
Section 5: RELATIONSHIP Function
RELATED Function
CROSSFILTER
Section 6: X FUNCTION
X FUNCTIONS
Section 7: FILTER Function
ALL Function
EARLIER and FILTER Function
LOOKUPVALUE
Section 8: STATISTICAL Function
DISTINCTCOUNT Function
RANKX Function
Section 9: TIME INTELLIGENCE Function
DATESYTD Function
DATEADD Function
SAMEPERIODLASTYEAR
Section 10: INFORMATION Function
CONTAINS FUNCTIONS
Section 11: NEW TABLE AND QUICK MEASURE
New Table
SUMMARIZECOLUMNS
Quick Measure
