Question

What are the common functions of DAX?

Answer 1

Some of the most common functions used by DAX are as follows:

• Date and Time Functions: DATE, DATEVALUE, TODAY, WEEKDAY, HOUR, MINUTE, MONTH, SECOND, CALENDAR, CALENDARAUTO, TIME, TIMEVALUE
• Information Functions: CONTAINS, CUSTOMDATA, LOOKUPVALUE, USERNAME, ISBLANK, ISERROR, ISEVEN, ISLOGICAL, ISNUMBER, ISODD, ISTEXT
• Mthematical and Trigonometric Functions: ABS, ACOS, CEILING, COMBINE, CURRENCY, ASIN, ATAN, COS, DEGREES, DIVIDE, EVEN, EXP, FACT
• Logical Functions: IF, AND, OR, SWITCH, NOT, TRUE, FALSE, IFERROR, IN
• Parent & Child Functions: PATH, PATHEITEM, PATHITEMREVERSE, PATHLENGTH, PATHCONTAINS
• Statistical Functions: ADDCOLUMNS, AVERAGE, AVERAGEA, BETA, MIN, MAX, MEDIAN, COUNT, GENERATE, etc.
• Text Functions: BLANK, CODE, CONCATENATE, EXACT, FIND.