DAX Guide
Functions
  • ABS
  • ACCRINT
  • ACCRINTM
  • ACOS
  • ACOSH
  • ACOT
  • ACOTH
  • ADDCOLUMNS
  • ADDMISSINGITEMS
  • ALL
  • ALLCROSSFILTERED
  • ALLEXCEPT
  • ALLNOBLANKROW
  • ALLSELECTED
  • ALLSELECTEDAPPLY
  • ALLSELECTEDREMOVE
  • ALWAYSAPPLY
  • AMORDEGRC
  • AMORLINC
  • AND
  • APPROXIMATEDISTINCTCOUNT
  • ASIN
  • ASINH
  • ATAN
  • ATANH
  • AVERAGE
  • AVERAGEA
  • AVERAGEX
  • BETA.DIST
  • BETA.INV
  • BITAND
  • BITLSHIFT
  • BITOR
  • BITRSHIFT
  • BITXOR
  • BLANK
  • CALCULATE
  • CALCULATETABLE
  • CALENDAR
  • CALENDARAUTO
  • CEILING
  • CHISQ.DIST
  • CHISQ.DIST.RT
  • CHISQ.INV
  • CHISQ.INV.RT
  • CLOSINGBALANCEMONTH
  • CLOSINGBALANCEQUARTER
  • CLOSINGBALANCEWEEK
  • CLOSINGBALANCEYEAR
  • COALESCE
  • COLLAPSE
  • COLLAPSEALL
  • COLUMNSTATISTICS
  • COMBIN
  • COMBINA
  • COMBINEVALUES
  • CONCATENATE
  • CONCATENATEX
  • CONFIDENCE.NORM
  • CONFIDENCE.T
  • CONTAINS
  • CONTAINSROW
  • CONTAINSSTRING
  • CONTAINSSTRINGEXACT
  • CONVERT
  • COS
  • COSH
  • COT
  • COTH
  • COUNT
  • COUNTA
  • COUNTAX
  • COUNTBLANK
  • COUNTROWS
  • COUNTX
  • COUPDAYBS
  • COUPDAYS
  • COUPDAYSNC
  • COUPNCD
  • COUPNUM
  • COUPPCD
  • CROSSFILTER
  • CROSSJOIN
  • CUMIPMT
  • CUMPRINC
  • CURRENCY
  • CURRENTGROUP
  • CUSTOMDATA
  • DATATABLE
  • DATE
  • DATEADD
  • DATEDIFF
  • DATESBETWEEN
  • DATESINPERIOD
  • DATESMTD
  • DATESQTD
  • DATESWTD
  • DATESYTD
  • DATEVALUE
  • DAY
  • DB
  • DDB
  • DEGREES
  • DETAILROWS
  • DISC
  • DISTINCT
  • DISTINCTCOUNT
  • DISTINCTCOUNTNOBLANK
  • DIVIDE
  • DOLLARDE
  • DOLLARFR
  • DURATION
  • EARLIER
  • EARLIEST
  • EDATE
  • EFFECT
  • ENDOFMONTH
  • ENDOFQUARTER
  • ENDOFWEEK
  • ENDOFYEAR
  • EOMONTH
  • ERROR
  • EVALUATEANDLOG
  • EVEN
  • EXACT
  • EXCEPT
  • EXP
  • EXPAND
  • EXPANDALL
  • EXPON.DIST
  • EXTERNALMEASURE
  • FACT
  • FALSE
  • FILTER
  • FILTERCLUSTER
  • FILTERS
  • FIND
  • FIRST
  • FIRSTDATE
  • FIRSTNONBLANK
  • FIRSTNONBLANKVALUE
  • FIXED
  • FLOOR
  • FORMAT
  • FV
  • GCD
  • GENERATE
  • GENERATEALL
  • GENERATESERIES
  • GEOMEAN
  • GEOMEANX
  • GROUPBY
  • GROUPCROSSAPPLY
  • GROUPCROSSAPPLYTABLE
  • HASH
  • HASONEFILTER
  • HASONEVALUE
  • HOUR
  • IF
  • IF.EAGER
  • IFERROR
  • IGNORE
  • INDEX
  • INFO.ALTERNATEOFDEFINITIONS
  • INFO.ANNOTATIONS
  • INFO.ATTRIBUTEHIERARCHIES
  • INFO.ATTRIBUTEHIERARCHYSTORAGES
  • INFO.CALCDEPENDENCY
  • INFO.CALCULATIONGROUPS
  • INFO.CALCULATIONITEMS
  • INFO.CATALOGS
  • INFO.CHANGEDPROPERTIES
  • INFO.COLUMNPARTITIONSTORAGES
  • INFO.COLUMNPERMISSIONS
  • INFO.COLUMNS
  • INFO.COLUMNSTORAGES
  • INFO.CSDLMETADATA
  • INFO.CULTURES
  • INFO.DATACOVERAGEDEFINITIONS
  • INFO.DATASOURCES
  • INFO.DELTATABLEMETADATASTORAGES
  • INFO.DEPENDENCIES
  • INFO.DETAILROWSDEFINITIONS
  • INFO.DICTIONARYSTORAGES
  • INFO.EXCLUDEDARTIFACTS
  • INFO.EXPRESSIONS
  • INFO.EXTENDEDPROPERTIES
  • INFO.FORMATSTRINGDEFINITIONS
  • INFO.FUNCTIONS
  • INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES
  • INFO.GROUPBYCOLUMNS
  • INFO.HIERARCHIES
  • INFO.HIERARCHYSTORAGES
  • INFO.KPIS
  • INFO.LEVELS
  • INFO.LINGUISTICMETADATA
  • INFO.MEASURES
  • INFO.MODEL
  • INFO.OBJECTTRANSLATIONS
  • INFO.PARQUETFILESTORAGES
  • INFO.PARTITIONS
  • INFO.PARTITIONSTORAGES
  • INFO.PERSPECTIVECOLUMNS
  • INFO.PERSPECTIVEHIERARCHIES
  • INFO.PERSPECTIVEMEASURES
  • INFO.PERSPECTIVES
  • INFO.PERSPECTIVETABLES
  • INFO.PROPERTIES
  • INFO.QUERYGROUPS
  • INFO.REFRESHPOLICIES
  • INFO.RELATEDCOLUMNDETAILS
  • INFO.RELATIONSHIPINDEXSTORAGES
  • INFO.RELATIONSHIPS
  • INFO.RELATIONSHIPSTORAGES
  • INFO.ROLEMEMBERSHIPS
  • INFO.ROLES
  • INFO.SEGMENTMAPSTORAGES
  • INFO.SEGMENTSTORAGES
  • INFO.STORAGEFILES
  • INFO.STORAGEFOLDERS
  • INFO.STORAGETABLECOLUMNS
  • INFO.STORAGETABLECOLUMNSEGMENTS
  • INFO.STORAGETABLES
  • INFO.TABLEPERMISSIONS
  • INFO.TABLES
  • INFO.TABLESTORAGES
  • INFO.VARIATIONS
  • INFO.VIEW.COLUMNS
  • INFO.VIEW.MEASURES
  • INFO.VIEW.RELATIONSHIPS
  • INFO.VIEW.TABLES
  • INT
  • INTERSECT
  • INTRATE
  • IPMT
  • ISAFTER
  • ISATLEVEL
  • ISBLANK
  • ISBOOLEAN
  • ISCROSSFILTERED
  • ISCURRENCY
  • ISDATETIME
  • ISDECIMAL
  • ISDOUBLE
  • ISEMPTY
  • ISERROR
  • ISEVEN
  • ISFILTERED
  • ISINSCOPE
  • ISINT64
  • ISINTEGER
  • ISLOGICAL
  • ISNONTEXT
  • ISNUMBER
  • ISNUMERIC
  • ISO.CEILING
  • ISODD
  • ISONORAFTER
  • ISPMT
  • ISSELECTEDMEASURE
  • ISSTRING
  • ISSUBTOTAL
  • ISTEXT
  • KEEPFILTERS
  • KEYWORDMATCH
  • LAST
  • LASTDATE
  • LASTNONBLANK
  • LASTNONBLANKVALUE
  • LCM
  • LEFT
  • LEN
  • LINEST
  • LINESTX
  • LN
  • LOG
  • LOG10
  • LOOKUP
  • LOOKUPVALUE
  • LOOKUPWITHTOTALS
  • LOWER
  • MATCHBY
  • MAX
  • MAXA
  • MAXX
  • MDURATION
  • MEDIAN
  • MEDIANX
  • MID
  • MIN
  • MINA
  • MINUTE
  • MINX
  • MOD
  • MONTH
  • MOVINGAVERAGE
  • MROUND
  • NAMEOF
  • NATURALINNERJOIN
  • NATURALJOINUSAGE
  • NATURALLEFTOUTERJOIN
  • NETWORKDAYS
  • NEXT
  • NEXTDAY
  • NEXTMONTH
  • NEXTQUARTER
  • NEXTWEEK
  • NEXTYEAR
  • NOMINAL
  • NONFILTER
  • NONVISUAL
  • NORM.DIST
  • NORM.INV
  • NORM.S.DIST
  • NORM.S.INV
  • NOT
  • NOW
  • NPER
  • ODD
  • ODDFPRICE
  • ODDFYIELD
  • ODDLPRICE
  • ODDLYIELD
  • OFFSET
  • OPENINGBALANCEMONTH
  • OPENINGBALANCEQUARTER
  • OPENINGBALANCEWEEK
  • OPENINGBALANCEYEAR
  • OR
  • ORDERBY
  • PARALLELPERIOD
  • PARTITIONBY
  • PATH
  • PATHCONTAINS
  • PATHITEM
  • PATHITEMREVERSE
  • PATHLENGTH
  • PDURATION
  • PERCENTILE.EXC
  • PERCENTILE.INC
  • PERCENTILEX.EXC
  • PERCENTILEX.INC
  • PERMUT
  • PI
  • PMT
  • POISSON.DIST
  • POWER
  • PPMT
  • PREVIOUS
  • PREVIOUSDAY
  • PREVIOUSMONTH
  • PREVIOUSQUARTER
  • PREVIOUSWEEK
  • PREVIOUSYEAR
  • PRICE
  • PRICEDISC
  • PRICEMAT
  • PRODUCT
  • PRODUCTX
  • PV
  • QUARTER
  • QUOTIENT
  • RADIANS
  • RAND
  • RANDBETWEEN
  • RANGE
  • RANK
  • RANK.EQ
  • RANKX
  • RATE
  • RECEIVED
  • RELATED
  • RELATEDTABLE
  • REMOVEFILTERS
  • REPLACE
  • REPT
  • RIGHT
  • ROLLUP
  • ROLLUPADDISSUBTOTAL
  • ROLLUPGROUP
  • ROLLUPISSUBTOTAL
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • ROW
  • ROWNUMBER
  • RRI
  • RUNNINGSUM
  • SAMEPERIODLASTYEAR
  • SAMPLE
  • SAMPLEAXISWITHLOCALMINMAX
  • SAMPLECARTESIANPOINTSBYCOVER
  • SEARCH
  • SECOND
  • SELECTCOLUMNS
  • SELECTEDMEASURE
  • SELECTEDMEASUREFORMATSTRING
  • SELECTEDMEASURENAME
  • SELECTEDVALUE
  • SHADOWCLUSTER
  • SIGN
  • SIN
  • SINH
  • SLN
  • SQRT
  • SQRTPI
  • STARTOFMONTH
  • STARTOFQUARTER
  • STARTOFWEEK
  • STARTOFYEAR
  • STDEV.P
  • STDEV.S
  • STDEVX.P
  • STDEVX.S
  • SUBSTITUTE
  • SUBSTITUTEWITHINDEX
  • SUM
  • SUMMARIZE
  • SUMMARIZECOLUMNS
  • SUMX
  • SWITCH
  • SYD
  • T.DIST
  • T.DIST.2T
  • T.DIST.RT
  • T.INV
  • T.INV.2T
  • TAN
  • TANH
  • TBILLEQ
  • TBILLPRICE
  • TBILLYIELD
  • TIME
  • TIMEVALUE
  • TOCSV
  • TODAY
  • TOJSON
  • TOPN
  • TOPNPERLEVEL
  • TOPNSKIP
  • TOTALMTD
  • TOTALQTD
  • TOTALWTD
  • TOTALYTD
  • TREATAS
  • TRIM
  • TRUE
  • TRUNC
  • UNICHAR
  • UNICODE
  • UNION
  • UPPER
  • USERCULTURE
  • USERELATIONSHIP
  • USERNAME
  • USEROBJECTID
  • USERPRINCIPALNAME
  • UTCNOW
  • UTCTODAY
  • VALUE
  • VALUES
  • VAR.P
  • VAR.S
  • VARX.P
  • VARX.S
  • VDB
  • WEEKDAY
  • WEEKNUM
  • WINDOW
  • XIRR
  • XNPV
  • YEAR
  • YEARFRAC
  • YIELD
  • YIELDDISC
  • YIELDMAT

Data types
  • Binary
  • Boolean
  • Currency
  • DateTime
  • Decimal
  • Integer
  • String
  • Variant

Operators
  • Addition (+)
  • And (&&)
  • Concatenation (&)
  • Division (/)
  • Equal to (=)
  • Exponentiation (^)
  • Greater than (>)
  • Greater than or equal to (>=)
  • IN
  • Less than (<)
  • Less than or equal to (<=)
  • Multiplication (*)
  • NOT
  • Not equal to (<>)
  • Or (||)
  • Strictly equal to (==)
  • Subtraction (-)
  • Table constructor { }

Statements
  • AXIS COLUMNS
  • AXIS ROWS
  • COLUMN
  • DEFINE
  • DENSIFY
  • EVALUATE
  • FUNCTION
  • GROUP
  • MEASURE
  • MPARAMETER
  • ORDER BY
  • RETURN