Power BI DAX Functions

This article shows the Power BI Dax functions, and the following are the list of available ones.

  1. Aggregate Functions
  2. AVERAGE Function
  3. COUNT Function
  4. DISTINCTCOUNT Function
  5. MIN Function
  6. MAX Function
  7. SUM Function
  8. STDEV.P Function
  9. STDEV.S Function
  10. VAR.P Function
  11. VAR.S Function
  12. MEDIAN Function

The remaining DAX functions are

The following is the list of Date and Time Functions available for writing DAX queries.

  1. DAY
  2. DATESMTD
  3. DATESQTD
  4. DATESYTD
  5. HOUR
  6. MINUTE
  7. MONTH
  8. NEXTDAY
  9. NEXTMONTH
  10. NEXTQUARTER
  11. NEXTYEAR
  12. PREVIOUSDAY
  13. PREVIOUSMONTH
  14. PREVIOUSQUARTER
  15. PREVIOUSYEAR
  16. SECOND
  17. YEAR

The following is the list of Text or String Functions available for writing DAX queries.

  1. LEN Function
  2. LEFT Function
  3. LOWER Function
  4. RIGHT Function
  5. UPPER Function
  6. UNICODE Function
  7. TRIM Function