➢ What is DAX, Calculated Column, Measures
➢ DAX Table and Column Name Syntax
➢ Creating Calculated Columns, Creating Measures
➢ Implicit Vs Explicit Measures
➢ Calculated Columns Vs Measures
➢ DAX Functions Categories
❖ DAX Date & Time Functions
▪ YEAR, MONTH, DAY
▪ WEEKDAY, WEEKNUM
▪ FORMAT (Text Function) à Month Name, Weekday Name
▪ DATE, TODAY, NOW
▪ HOUR, MINUTE, SECOND, TIME
▪ DATEDIFF, CALENDAR
❖ DAX Text Functions
▪ LEN, CONCATENATE (&)
▪ LEFT, RIGHT, MID
▪ UPPER, LOWER
▪ TRIM, SUBSTITUTE, BLANK
❖ DAX Logical Functions
▪ IF
▪ TRUE, FALSE
▪ NOT, OR, IN, AND
▪ IFERROR
▪ SWITCH
❖ DAXMath and Statistical Functions
▪ INT
▪ ROUND, ROUNDUP, ROUNDDOWN
▪ DIVIDE
▪ SQRT, FACT
▪ SUM, SUMX
▪ MIN, MINX
▪ MAX, MAXX
▪ COUNT, COUNTX
▪ AVERAGE
▪ COUNTROWS, COUNTBLANK
❖ DAX Filter Functions
▪ CALCULATE
▪ ALL
▪ RELATED
❖ DAX Time Intelligence Functions
▪ TOTALMTD, TOTALQTD, TOTALYTD
▪ PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
▪ YOY Growth
▪ MOM Growth