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