Power BI DAX Functions

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

• ALL
• ALLSELECTED
• ALLEXCEPT
• CALCULATE
• CALCULATETABLE
• FILTER
• LOOKUPVALUE
• OFFSET

Table Manipulation DAX Functions

• ADDCOLUMNS
• SUMMARIZE
• GROUPBY
• DATATABLE
• UNION
• EXCEPT
• INTERSECT
• NATURALINNERJOIN and NATURALOUTERJOIN
• ROW

Logical DAX Functions

• IFERROR
• SWITCH
• IF
• AND(&&)
• OR(||)
• NOT
• COALESCE

Text DAX Functions

• UPPER 
• LOWER
• LEFT
• RIGHT
• CONCATENATE
• CONCATENATEX 
• LEN
• SUBSTITUTE
• MID
• FIND
• SEARCH
• REPT
• EXACT

Math & Trig Functions

• SUM Vs SUMX 

Information Functions

• USERPRINCIPALNAME()

Relationship Functions

• USERELATIONSHIP
• RELATEDTABLE

Statistical DAX Functions

• COUNTROWS
• DISTINCTCOUNT
• COUNTBLANK
• COUNT, COUNTA & COUNTX
• MIN, MINA & MINX 
• MAX, MAXA & MAXA
• AVERAGE, AVERAGEA, AVERAGEX

Time Intelligence DAX Functions

• OPENING BALANCE DAX & CLOSING BALANCE DAX
  1. OPENINGBALANCEMONTH
  2. OPENINGBALANCEQUARTER
  3. OPENINGBALANCEYEAR
  4. CLOSINGBALANCEMONTH
  5. CLOSINGBALANCEQUARTER
  6. CLOSINGBALANCEYEAR
• FIRSTNONBLANK
• LASTNONBLANK
• PREVIOUSDAY
• PREVIOUSMONTH
• PREVIOUSQUARTER
• PREVIOUSYEAR
• TOTALMTD
• TOTALQTD
• TOTALYTD
• SAMEPERIODLASTYEAR
• PARALLELPERIOD
• NEXTDAY
• NEXTMONTH

Parent and Child Functions

• PATH
• PATHCONTAINS
• PATHLENGTH
• PATHITEM

Date & Time DAX Functions

• DATE & TIME DAX Functions
  1. CALENDAR
  2. CALENDARAUTO
  3. DATE
  4. DATEDIFF
  5. DATEVALUE
  6. DAY
  7. YEAR
  8. MONTH
  9. QUARTER
  10. HOUR
  11. MINUTE
  12. SECOND
  13. EDATE
  14. EOMONTH
  15. TIME
  16. TIMEVALUE
  17. NOW
  18. TODAY
  19. WEEKDAY
  20. WEEKNUM
  21. YEARFRAC

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