Microsoft Power BI, Microsoft Power BI DAX, DAX function

Description

In this course, you will learn :

• Be expert on how to create DAX formula
• Learn calculated column, measures, and tables in DAX
• Be able to solve the problem statement using various DAX function

Syllabus :

1. Introduction

• Getting Started Preview
• Syntax
• Intro to DAX

 

2. DATE and TIME Function

• WEEKDAY Function
• EDATE Function
• EMONTH Function
• DATEDIFF and TODAY Function

 

3. TEXT Function

• FORMAT Function
• COMBINEVALUES Function
• LEFT and FIND Function

 

4. LOGICAL Function

• IF Function
• NESTEDIF Function
• AND FUNCTION
• OR Function
• SWITCH Function

 

5. RELATIONSHIP Function

• RELATED Function
• CROSSFILTER

 

6. X FUNCTION

• X FUNCTIONS

 

7. FILTER Function

• ALL Function
• EARLIER and FILTER Function
• LOOKUPVALUE

 

8. STATISTICAL Function

• DISTINCTCOUNT Function
• RANKX Function

 

9. TIME INTELLIGENCE Function

• DATESYTD Function
• DATEADD Function
• SAMEPERIODLASTYEAR

 

10. INFORMATION Function

• CONTAINS FUNCTIONS

 

11. NEW TABLE AND QUICK MEASURE

• New Table
• SUMMARIZECOLUMNS

Show more