Data Analysis Expressions (DAX)

DAY – DAX Guide

Returns a number from 1 to 31 representing the day of the month.

dax.guide

Filter functions (DAX) - DAX

Learn more about: Filter functions

learn.microsoft.com

1. Aggregation Functions

• SUM, SUMX, AVERAGE, AVERAGEX, AVERAGEA
• MIN, MINX, MAX, MAXX
• PRODUCT, PRODUCTX
• COUNT, COUNTA, COUNTAX, COUNTROWS, COUNTBLANK, DISTINCTCOUNT
• MEDIAN, MEDIANX
• STDEV.P, STDEV.S, STDEVX.P, STDEVX.S
• VAR.P, VAR.S, VARX.P, VARX.S

2. Date and Time Functions

• DATE, DATEDIFF, DATEVALUE, TIME, TIMEVALUE
• YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
• NOW, TODAY, WEEKDAY, WEEKNUM, QUARTER, EOMONTH
• STARTOFMONTH, ENDOFMONTH, STARTOFQUARTER, ENDOFQUARTER, STARTOFYEAR, ENDOFYEAR
• CALENDAR, CALENDARAUTO

3. Time Intelligence Functions

• TOTALYTD, TOTALQTD, TOTALMTD
• DATESYTD, DATESQTD, DATESMTD
• SAMEPERIODLASTYEAR, PARALLELPERIOD, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
• NEXTMONTH, NEXTQUARTER, NEXTYEAR
• FIRSTDATE, LASTDATE, FIRSTNONBLANK, LASTNONBLANK, DATESBETWEEN, CLOSINGBALANCEYEAR, OPENINGBALANCEYEAR

4. Filter Functions

• CALCULATE, CALCULATETABLE
• FILTER, ALL, ALLSELECTED, ALLEXCEPT, REMOVEFILTERS
• KEEPFILTERS, VALUES, SELECTEDVALUE
• CROSSFILTER, USERELATIONSHIP

5. Logical Functions

• IF, IFERROR, SWITCH, AND, OR, NOT, TRUE, FALSE

6. Mathematical and Trigonometric Functions

• ABS, CEILING, FLOOR, DIVIDE, MOD, ROUND, ROUNDDOWN, ROUNDUP
• POWER, EXP, LN, LOG, LOG10, PI, SQRT, TRUNC, INT
• Trigonometric: COS, COSH, SIN, SINH, TAN, TANH, ACOS, ASIN, ATAN, ATAN2

7. Text Functions

• CONCATENATE, CONCATENATEX, LEFT, RIGHT, MID, UPPER, LOWER, TRIM, LEN, REPLACE, SEARCH, FIND, SUBSTITUTE, FORMAT, UNICHAR, UNICODE

8. Information Functions

• ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT, IFERROR, ERROR

9. Parent-Child Functions

• PATH, PATHITEM, PATHITEMREVERSE, PATHLENGTH, LOOKUPVALUE

10. Table Manipulation Functions

• SELECTCOLUMNS, ADDCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, CROSSJOIN, NATURALINNERJOIN, NATURALLEFTOUTERJOIN, EXCEPT, INTERSECT, UNION, GENERATE, GENERATEALL

11. Statistical Functions

• RANKX, TOPN, PERCENTILE.EXC, PERCENTILE.INC, MEDIANX, VARX.P, VARX.S, STDEVX.P, STDEVX.S

12. Relationship Functions

• RELATED, RELATEDTABLE, USERELATIONSHIP, CROSSFILTER, TREATAS

13. Evaluation Context Functions

• HASONEVALUE, HASONEFILTER, ISFILTERED, ISCROSSFILTERED, SELECTEDVALUE, VALUES, ALLSELECTED

14. Financial Functions

• PMT, IPMT, PPMT, FV, NPER, RATE

15. Other Functions

• UNION, EXCEPT, INTERSECT
• BLANK, ERROR, VAR, RETURN, DEFINE, SELECTEDCOLUMNS