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