 ## 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
• 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