Mastering in DAX for Power BI

Course details

COURSE CONTENT :

• DAX (Data Analysis Expressions)
  
• Purpose of Data Analysis Expressions (DAX)
  
• Scope of Usage with DAX. Usability Options
  
• DAX Context : Row Context and Filter Context
  
• DAX Entities : Calculated Columns and Measures
  
• DAX Data Types : Numeric, Boolean, Variant, Currency
  
• DAX Operators & Symbols. Usage. Operator Priority
  
• Parenthesis, Comparison, Arithmetic, Text, Logic
  
• DAX Functions and Types: Table Valued Functions
  
• Filter, Aggregation and Time Intelligence Functions
  
• Information Functions, Logical, Parent-Child Functions
  
• Statistical and Text Functions. Formulas and Queries
  
• Syntax Requirements with DAX.
  
• Naming Conventions and DAX Format Representation
  
• Working with Special Characters in Table Names
  
• Attribute / Column Scope with DAX - Examples
  
• Measure / Column Scope with DAX - Examples
  
• YTD, QTD, MTD Calculations with DAX
  
• Time Intelligence Functions with DAX
  
• DATESYTD, DATESQTD, DATESMTD
  
• ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
  
• FIRSTDATE, LASTDATE, DATESBETWEEN
  
• CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
  
• SAMEPERIOD and PREVIOUSMONTH,QUARTER