Aggregate Functions

DAX has a number of aggregate functions.

• MIN
• MAX
• Average
• SUM
• SUMX

Counting Functions

Other counting functions in DAX include −

• DISTINCTCOUNT
• COUNT
• COUNTA
• COUNTROWS
• COUNTBLANK

Logical Functions

Following are the collection of Logical functions −

• AND
• OR
• NOT
• IF
• IFERROR

 stringFunctions

• REPLACE
• SEARCH
• UPPER
• FIXED
• CONCATENATE

DATE Functions

• DATE
• HOUR
• WEEKDAY
• NOW
• EOMONTH

INFORMATION Functions

• ISBLANK
• ISNUMBER
• ISTEXT
• ISNONTEXT
• ISERROR