DAX Function Guide

DAX Function Guide

January 16, 2020 No Comments

A

ABS
ACOS
ACOSH
ADDCOLUMNS
ADDMISSINGITEMS
ALL
ALLCROSSFILTERED

ALLEXCEPT
ALLNOBLANKROW
ALLSELECTED
AND
APPROXIMATEDISTINCTCOUNT
ASIN

ASINH
ATAN
ATANH
AVERAGE
AVERAGEA
AVERAGEX

B

BETA.DIST

BETA.INV

BLANK

C

CALCULATE
CALCULATETABLE
CALENDAR
CALENDARAUTO
CEILING
CHISQ.INV
CHISQ.INV.RT
CLOSINGBALANCEMONTH
CLOSINGBALANCEQUARTER
CLOSINGBALANCEYEAR
CODE

COMBIN
COMBINA
CONCATENATE
CONCATENATEX
CONFIDENCE.NORM
CONFIDENCE.T
CONTAINS
CONTAINSSTRING
CONTAINSSTRINGEXACT
CONVERT
COS

COSH
COUNT
COUNTA
COUNTAX
COUNTBLANK
COUNTROWS
COUNTX
CROSSFILTER
CROSSJOIN
CURRENCY
CUSTOMDATA

D

DATATABLE
DATE
DATEADD
DATEDIFF
DATESBETWEEN
DATESINPERIOD

DATESMTD
DATESQTD
DATESYTD
DATEVALUE
DAY
DEGREES

DISTINCT (column)
DISTINCT (table)
DISTINCTCOUNT
DISTINCTCOUNTNOBLANK
DIVIDE

E

EARLIER
EARLIEST
EDATE
ENDOFMONTH
ENDOFQUARTER

ENDOFYEAR
EOMONTH
ERROR
EVEN

EXACT
EXCEPT
EXP
EXPON.DIST

F

FACT
FALSE
FILTER
FILTERS

FIND
FIRSTDATE
FIRSTNONBLANK

FIXED
FLOOR
FORMAT

G

GCD
GENERATE
GENERATEALL

GENERATESERIES
GEOMEAN

GEOMEANX
GROUPBY

H

HASONEFILTER

HASONEVALUE

HOUR

I

IF
IFERROR
IN
IN Operator / CONTAINSROW function
INT
INTERSECT

ISBLANK
ISCROSSFILTERED
ISEMPTY
ISERROR
ISEVEN
ISFILTERED
ISINSCOPE

ISLOGICAL
ISNONTEXT
ISNUMBER
ISO.CEILING
ISONORAFTER
ISSELECTEDMEASURE
ISTEXT

J

K

KEEPFILTERS

L

LASTDATE
LASTNONBLANK
LCM
LEFT

LEN
LN
LOG

LOG10
LOOKUPVALUE
LOWER

M

MAX
MAXA
MAXX
MEDIAN
MEDIANX

MID
MIN
MINA
MINUTE

MINX
MOD
MONTH
MROUND

N

NATURALINNERJOIN
NATURALLEFTOUTERJOIN
NEXTDAY
NEXTMONTH

NEXTQUARTER
NEXTYEAR
NORM.DIST
NORM.INV

NORM.S.DIST
NORM.S.INV
NOT
NOW

O

ODD
OPENINGBALANCEMONTH

OPENINGBALANCEQUARTER
OPENINGBALANCEYEAR

OR

P

PARALLELPERIOD
PATH
PATHCONTAINS
PATHITEM
PATHITEMREVERSE
PATHLENGTH
PERCENTILE.EXC

PERCENTILE.INC
PERCENTILEX.EXC
PERCENTILEX.INC
PI
POISSON.DIST
POWER

PREVIOUSDAY
PREVIOUSMONTH
PREVIOUSQUARTER
PREVIOUSYEAR
PRODUCT
PRODUCTX

Q

QUOTIENT

R

RADIANS
RAND
RANDBETWEEN
RANK.EQ
RANKX

RELATED
RELATEDTABLE
REMOVEFILTERS
REPLACE
REPT

RIGHT
ROUND
ROUNDDOWN
ROUNDUP
ROW

S

SAMEPERIODLASTYEAR
SAMPLE
SEARCH
SECOND
SELECTCOLUMNS
SELECTEDMEASURE
SELECTEDMEASUREFORMATSTRING
SELECTEDMEASURENAME
SELECTEDVALUE

SIGN
SIN
SINH
SQRT
SQRTPI
STARTOFMONTH
STARTOFQUARTER
STARTOFYEAR
STDEV.P
STDEV.S

STDEVX.P
STDEVX.S
SUBSTITUTE
SUBSTITUTEWITHINDEX
SUM
SUMMARIZE
SUMMARIZECOLUMNS
SUMX
SWITCH

T

T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2t
TAN

TANH
TIME
TIMEVALUE
TODAY
TOPN
TOTALMTD

TOTALQTD
TOTALYTD
TREATAS
TRIM
TRUE
TRUNC

U

UNICHAR
UNION
UPPER

USERELATIONSHIP
USERNAME

UTCNOW
UTCTODAY

V

VALUE
VALUES
VAR

VAR.P
VAR.S

VARX.P
VARX.S

W

WEEKDAY

WEEKNUM

 

X

XIRR

XNPV

 

Y

YEAR

YEARFRAC

 

Z