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
udemy.com/course/microsoft-power-bi-dax-foundation-from-scratch/?referralCode=27C542BA7BB60D147437
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
- FORMAT Function in Power BI using DAX | TEXT Function | #powerbi #dax ( Download)
- DAX Format Function - A few Awesome Tricks ( Download)
- Most useful TEXT function DAX you need | Power BI ( Download)
- Create a DateKey YYYYMMDD format using DAX Format Function Power BI ( Download)
- Format Function (DAX) - DAX Format Function In Power BI Desktop | DAX Tutorials ( Download)
- how to convert numbers into text in power bi desktop | real time dax functions ( Download)
- Power BI | Format Function| How to use Format function in power bi, #powerbi #Dax learning ( Download)
- Extracting Characters from Power BI Strings using DAX Text Functions | LEFT/ RIGHT/ SEARCH & More! ( Download)
- DAX | Power BI | TEXT | EXACT, FIXED, LEN, REPT, LOWER & UPPER Functions ( Download)
- Value() DAX Text Function | Power BI | Type Cast ( Download)
- DAX Language - FORMAT Function in Power BI ( Download)
- No More DAX Power BI’s NEW Feature Explained (File Included) ( Download)
- Extract Month Short Form from a date in Power BI using DAX format function ( Download)
- DAX - Text Functions Guide | Power BI ( Download)
- Digging into DYNAMIC format strings for DAX Measures in Power BI ( Download)
