1. Aggregation Functions
1. Basic Aggregation Functions (5)
SUM, AVERAGE, MIN, MAX, PRODUCT
2. A-Variant Functions (3)
AVERAGEA, MAXA, MINA
3. Counting Functions (4)
COUNT, COUNTA, COUNTBLANK, COUNTROWS
4. Distinct Counting Functions (3)
DISTINCTCOUNT, DISTINCTCOUNTNOBLANK, APPROXIMATEDISTINCTCOUNT
5. Iterator (X) Functions (6)
SUMX, AVERAGEX, COUNTX, COUNTAX, MAXX, MINX, PRODUCTX
2. Date and Time Functions
1. Calendar Functions
CALENDAR, CALENDARAUTO
2. Date Construction and Conversion Functions
DATE, DATEVALUE, TIME, TIMEVALUE
3. Current Date and Time Functions
TODAY, NOW, UTCTODAY, UTCNOW
4. Date Part Extraction Functions
DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, QUARTER, WEEKDAY, WEEKNUM
5. Date Arithmetic and Interval Functions
DATEDIFF, EDATE, EOMONTH, YEARFRAC, NETWORKDAYS
3. Time Intelligence Functions
1. Opening and Closing Balance Functions
OPENINGBALANCEWEEK, OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR
CLOSINGBALANCEWEEK, CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR
2. Date Interval and Range Functions
DATEADD, DATESBETWEEN, DATESINPERIOD, PARALLELPERIOD
SAMEPERIODLASTYEAR
3. Period-to-Date Functions
DATESWTD, DATESMTD, DATESQTD, DATESYTD
TOTALWTD, TOTALMTD, TOTALQTD, TOTALYTD
4. Start and End of Period Functions
STARTOFWEEK, STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR
ENDOFWEEK, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR
5. Next and Previous Period Functions
NEXTDAY, NEXTWEEK, NEXTMONTH, NEXTQUARTER, NEXTYEAR
PREVIOUSDAY, PREVIOUSWEEK, PREVIOUSMONTH, PREVIOUSQUARTER
PREVIOUSYEAR
6. Boundary and Reference Date Functions
FIRSTDATE, LASTDATE
4. Filter Functions
1. Filter Functions
CALCULATE, CALCULATETABLE
FILTER, ALL, ALLSELECTED, ALLEXCEPT, REMOVEFILTERS
KEEPFILTERS, VALUES, SELECTEDVALUE
ALLNOBLANKROW, ALLCROSSFILTERED
2. Calculation Functions
CALCULATE, CALCULATETABLE
FILTER, KEEPFILTERS
3. Row Context Functions
EARLIER, EARLIEST
4. Lookup & Relationship Functions
LOOKUPVALUE, LOOKUP, LOOKUPWITHTOTALS
USERELATIONSHIP, CROSSFILTER
5. Window & Ranking Functions
INDEX, OFFSET, RANGE, WINDOW
ORDERBY, PARTITIONBY, MATCHBY
RANK, ROWNUMBER, RUNNINGSUM, MOVINGAVERAGE
6. Visual Calculation Functions
FIRST, LAST, NEXT, PREVIOUS
7. Selection Functions
SELECTEDVALUE
5. Logical Functions
1. Logical Functions
AND, OR, NOT, IF, IF.EAGER, IFERROR, SWITCH, TRUE, FALSE, COALESCE
2. Bitwise Functions
BITAND, BITOR, BITXOR, BITLSHIFT, BITRSHIFT
6. Mathematical and Trigonometric Functions
1. Basic Arithmetic and Sign Functions
ABS, SIGN, DIVIDE, QUOTIENT, MOD
2. Rounding Functions
ROUND, ROUNDDOWN, ROUNDUP, INT, TRUNC
CEILING, ISO.CEILING, FLOOR, EVEN, ODD, MROUND
3. Exponential and Logarithmic Functions
EXP, LN, LOG, LOG10, POWER, SQRT, SQRTPI
4. Trigonometric Functions
SIN, COS, TAN, COT, PI, RADIANS, DEGREES
5. Inverse Trigonometric Functions
ASIN, ACOS, ATAN, ACOT
6. Hyperbolic Functions
SINH, COSH, TANH, COTH, ASINH, ACOSH, ATANH, ACOTH
7. Random and Statistical Functions
RAND, RANDBETWEEN, FACT, GCD, LCM
8. Conversion and Data Type Functions
CONVERT, CURRENCY
7. Text Functions
1. Text Combination Functions
COMBINEVALUES, CONCATENATE, CONCATENATEX
2. Text Comparison and Search Functions
EXACT, FIND, SEARCH
3. Text Extraction Functions
LEFT, RIGHT, MID
4. Text Replacement and Cleaning Functions
REPLACE, SUBSTITUTE, TRIM
5. Text Length and Repetition Functions
LEN, REPT
6. Text Case Conversion Functions
LOWER, UPPER
7. Number and Text Conversion Functions
VALUE, FORMAT, FIXED
8. Unicode Functions
UNICHAR, UNICODE
8. Information Functions
1. Containment and Existence Functions
CONTAINS, CONTAINSROW, CONTAINSSTRING, CONTAINSSTRINGEXACT
2. Value and Type Checking Functions
ISBLANK, ISBOOLEAN, ISLOGICAL, ISCURRENCY, ISDECIMAL, ISDATETIME
ISDOUBLE, ISINT64, ISINTEGER, ISNONTEXT, ISNUMBER, ISNUMERIC
ISODD, ISEVEN, ISSTRING, ISTEXT, ISERROR
3. Filter and Context Evaluation Functions
HASONEFILTER, HASONEVALUE, ISFILTERED, ISCROSSFILTERED, ISINSCOPE
ISAFTER, ISONORAFTER, ISEMPTY, ISSUBTOTAL, NONVISUAL
4. Calculation Item and Measure Context Functions
ISSELECTEDMEASURE, SELECTEDMEASURE, SELECTEDMEASUREFORMATSTRING, SELECTEDMEASURENAME
5. User and Connection Information Functions
CUSTOMDATA, USERCULTURE, USERNAME, USEROBJECTID, USERPRINCIPALNAME
6. Model and Metadata Functions
COLUMNSTATISTICS
9. Parent-Child Functions
1. Hierarchy Path Functions
PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH
10. Table Manipulation Functions
1. Table Manipulation Functions
ADDCOLUMNS, SELECTCOLUMNS, ROW, DATATABLE, Table Constructor
2. Table Combination & Join Functions
CROSSJOIN, UNION, NATURALINNERJOIN, NATURALLEFTOUTERJOINGENERATE, GENERATEALL, SUBSTITUTEWITHINDEX, TREATAS
3. Table Filtering & Comparison Functions
FILTERS, EXCEPT, INTERSECT, TOPN, VALUES, DISTINCT column, DISTINCT table
4. Table Generation Functions
GENERATESERIES, ADDMISSINGITEMS, DETAILROWS
5. Grouping & Summarization Functions
GROUPBY, SUMMARIZE, SUMMARIZECOLUMNS, CURRENTGROUP
6. Rollup & Hierarchical Aggregation Functions
ROLLUP, ROLLUPGROUP, ROLLUPADDISSUBTOTAL, ROLLUPISSUBTOTAL
7. Utility & Modifier Functions
IGNORE
11. Statistical Functions
1. Distribution Functions
BETA.DIST, BETA.INVCHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RTEXPON.DIST, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV
POISSON.DIST, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2t
2. Descriptive Statistics Functions
GEOMEAN, GEOMEANX, MEDIAN, MEDIANXSTDEV.P, STDEV.S, STDEVX.P, STDEVX.SVAR.P, VAR.S, VARX.P, VARX.S
3. Regression and Trend Analysis Functions
LINEST, LINESTX
4. Ranking and Percentile Functions
RANK.EQ, RANKX
PERCENTILE.EXC, PERCENTILE.INC
PERCENTILEX.EXC, PERCENTILEX.INC
5. Combinatorics and Probability Functions
COMBIN, COMBINA, PERMUT, CONFIDENCE.NORM, CONFIDENCE.T
6. Sampling Function
SAMPLE
12. Relationship Functions
RELATED,RELATEDTABLEUSERELATIONSHIPCROSSFILTERTREATAS
13. Financial Functions
1. Interest and Investment Functions
ACCRINT, ACCRINTM, EFFECT, NOMINAL, INTRATE
RATE, RRI, PDURATION, NPER, FV, PV
PMT, IPMT, PPMT, ISPMT
2. Security and Bond Pricing Functions
PRICE, PRICEDISC, PRICEMATYIELD, YIELDDISC, YIELDMATDISC, RECEIVEDODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELDCOUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCDTBILLEQ, TBILLPRICE, TBILLYIELDDURATION, MDURATION
3. Depreciation and Amortization Functions
AMORDEGRC, AMORLINC
DB, DDB, SLN, SYD, VDB
4. Currency and Conversion Functions
DOLLARDE, DOLLARFR
5. Cash Flow Analysis Functions
XIRR, XNPV, CUMIPMT, CUMPRINC
14. Other Functions
1. Value and Error Handling Functions
BLANK, ERROR, EVALUATEANDLOG
2. External and Conversion Functions
EXTERNALMEASURE, TOCSV, TOJSON
15. New DAX functions
1. Visual and Lookup Functions
LOOKUP, LOOKUPWITHTOTALS
FIRST, LAST, NEXT, PREVIOUS
2. Window and Ranking Functions
MATCHBY, RANK, ROWNUMBER
3. Regression Functions
LINEST, LINESTX
⚡ Complete DAX Functions Database
This centralized database contains all DAX functions with detailed descriptions, syntax, categories, and documentation links. Use the views to filter by category or search for specific functions.