Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models.
Power BI support more then 200 types of DAX functions like- Date & Time functions, Filter functions, Text functions, Information functions, Logical functions, Time intelligence functions, Mathematical functions etc.
Filter DAX Functions
Table Manipulation DAX Functions
- ADDCOLUMNS
- SUMMARIZE
- GROUPBY
- DATATABLE
- UNION
- EXCEPT
- INTERSECT
- NATURALINNERJOIN and NATURALOUTERJOIN
- ROW
Logical DAX Functions
Text DAX Functions
Information Functions
Relationship Functions
Aggregations DAX Functions
- COUNTROWS
- DISTINCTCOUNT
- COUNTBLANK
- COUNT, COUNTA & COUNTX
- MIN, MINA & MINX
- MAX, MAXA & MAXA
- AVERAGE, AVERAGEA, AVERAGEX
- SUM Vs SUMX
Time Intelligence DAX Functions
- OPENING BALANCE DAX & CLOSING BALANCE DAX
- OPENINGBALANCEMONTH
- OPENINGBALANCEQUARTER
- OPENINGBALANCEYEAR
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- FIRSTNONBLANK
- LASTNONBLANK
- PREVIOUSDAY
- PREVIOUSMONTH
- PREVIOUSQUARTER
- PREVIOUSYEAR
- TOTALMTD
- TOTALQTD
- TOTALYTD
- SAMEPERIODLASTYEAR
- PARALLELPERIOD
- NEXTDAY
- NEXTMONTH
Parent and Child Functions
Statistical DAX Functions
Date & Time DAX Functions
- DATE & TIME DAX Functions
- CALENDAR
- CALENDARAUTO
- DATE
- DATEDIFF
- DATEVALUE
- DAY
- YEAR
- MONTH
- QUARTER
- HOUR
- MINUTE
- SECOND
- EDATE
- EOMONTH
- TIME
- TIMEVALUE
- NOW
- TODAY
- WEEKDAY
- WEEKNUM
- YEARFRAC
- Exploring DateTime Functions in DAX: Syntax, Examples, and Common Queries
Some other Important DAX topics
- Quick Measure Suggestions
- Check Table 1 Value exist or not in Table 2 when there is no relationship between both tables
- Create a calendar table in power bi to using DAX functions
- Power BI Change display unit based on values in table visual
- Cumulative Total/ Running Total in Power BI
- Set functions in DAX – UNION, INTERSECT & EXCEPT
- How to add line breaks in a string of text in DAX measure
- LOOKUPVALUE DAX with Parent-child hierarchy functions
- Displaying a Text message when no data exist in Power BI visual
- DAX shortcut keys in Power BI Desktop
- Display Top 2 products for each region in Power BI