Mastering DAX
Course Duration & Payment Details
Days: Monday & Wednesday
Timing: 07:00 to 09:30pm
Duration: 20 hours
Starting from: Monday, 04 January 2021
Last date of registration: Friday, 25 December 2020
Actual Fee: 18000/- | Early bird discount: 9000/-
How to Pay: Online Payment
Bank: Habib Bank Limited (26 street, Badar Commercial, DHA Karachi)
Title: Irfan
Account No: 0011557900292501 | PK02HABB0011557900292501
Mastering DAX Outline
-
Introduction to DAX
- What is DAX?
- Data type and operators
- Syntax of DAX
- Understanding calculated columns and measures
- Why is a measure more efficient than a column?
- Creating calculated columns
- Formatting DAX code
- Implicit and explicit measures
- Understanding filter context
- Understanding Aggregations filter context
- Iteration / Row context
- Measure referencing
- Editing / Deleting measures
- Logical Operations
- Using variables to simplify formulas
- Writing comments in formulas
- What are Quick Measures?
- Quick measure feature
-
Relationship
- Working with Multiple tables
- Defining Relationship
- Editing and handling multiple relationships
-
Measures
- Implicit and explicit measures
- Measure referencing
- Editing / deleting measures
-
Date & Time Functions
- CALENDAR
- CALENDARAUTO
- DATE
- DATEDIFF
- DATEVALUE
- DAY
- EDATE
- EOMONTH
- HOUR
- MINUTE
- SECOND
- TIME
- TIMEVALUE
- MONTH
- YEAR
- FORMAT
- NOW
- TODAY
- WEEKDAY
- WEEKNUM
-
Filter Functions
- ALL
- ALLEXCEPT
- ALLSELECTED
- CALCULATE
- CROSSFILTER
- EARLIER
- FILTER
- HASONEVALUE
- ISFILTERED
- RELATED
- USERELATIONSHIP
- VALUES
-
Math & Trig Functions
- ABS
- CEILING
- DIVIDE
- ROUND
- ROUNDUP
- SUM
- SUMX
-
Logical Functions
- IF
- IFERROR
- AND
- OR
- SWITCH
-
Time Intelligence Expressions
- DATESMTD
- DATESQTD
- DATESYTD
- DATEADD
- DATESBETWEEN
- PERVIOUSDAY
- PERVIOUSMONTH
- PERVIOUSQUARTER
- PERVIOUSYEAR
- RUNNING TOTAL
- SAMEPERIODLASTYEAR
-
Statistical Function
- AVERAGE
- AVERAGEX
- COUNT
- COUNTA
- COUNTBLANK
- COUNTROWS
- COUNTX
- CROSSJOIN
- DISTINCTCOUNT
- MAX
- MAXX
- MIN
- MINX
- MEDIANX
- RANKX
- SUMARIZE
- TOPN
-
Text Functions
- CONCATENATE
- FORMAT
- LEFT
- LEN
- LOWER
- REPT
- RIGHT
- TRIM
- UNICHAR
- UPPER
- VALUE
- Top N Values, Top N Filter, Top Order calculations, Top 10 Customers, Dynamic
- Date Table, More Scenarios of Using Calculated Tables, Performance Consideration
