Objectives
In this course, you will learn to:
• Perform basic calculations
• Work with context in the data model
• Perform more advanced calculations
• Work with time
• Enhance the user experience
DAX functions that are covered in this class include:
• Date and time functions: CALENDAR(), DATE(), DATEDIFF(), NOW(), WEEKDAY(), WEEKNUM(), YEAR(), MONTH(), DAY()
• Filter functions: ALL(), ALLCROSSFILTERED(), ALLEXCEPT(), ALLSELECTED(), CALCULATE(), CALCULATETABLE(), FILTER(), KEEPFILTERS(), LOOKUPVALUE(), REMOVEFILTERS()
• Information functions: CONTAINS(), HASONEFILTER(), HASONEVALUE(), ISBLANK(), ISEMPTY(), ISERROR(), USERNAME()
• Logical functions: AND(), COALESCE(), IF(), IF.EAGER(), IFERROR(), NOT(), OR(), SWITCH(), TRUE(), FALSE()
• Math and Statistical Functions: DIVIDE(), SUM(), SUMX(), AVERAGE(), AVERAGEX(), COUNT(), COUNTBLANK(), COUNTROWS(), COUNTX(), DISTINCTCOUNT(), MAX(), MAXX(), MEDIAN(), MEDIANX(), MIN(), MINX(), RANKX()
• Table manipulation functions: CROSSJOIN(), DATATABLE(), NATURALINNERJOIN(), VALUES()
• Text functions: CONCATENATEX(), FIND(), LEFT(), LEN(), MID(), REPLACE(), SEARCH(), TRIM(), VALUE()
• Time intelligence functions: DATEADD(), DATESBETWEEN(), DATESMTD(), DATESQTD(), DATESYTD(), PARALLELPERIOD(), SAMEPERIODLASTYEAR(), TOTALMTD(), TOTALQTD(), TOTALYTD