DAX Function Guide - Enterprise DNA | Knowledge Base

The Wayback Machine - https://web.archive.org/web/20220528172606/https://www.enterprisedna.co/kb/dax-guide/dax-function-guide/

DAX Function Guide

DAX Function Guide

Sam McKay 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

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

J

K

KEEPFILTERS

L

LASTDATE
LASTNONBLANK
LCM
LEFT

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

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

R

RADIANS
RAND
RANDBETWEEN
RANK.EQ
RANKX

RELATED
RELATEDTABLE
REMOVEFILTERS
REPLACE
REPT

RIGHT
ROUND
ROUNDDOWN
ROUNDUP
ROW

S

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

W

X

XIRR

XNPV

Y

YEAR

Z

“I truly appreciate your efforts in helping the ones who needed to get more professional help in using Power BI. Your videos are A+ and really helpful+inspiring for me. I wish you the best from Turkey.”

Erol Yücel

“I have taken couple of courses from Sam from Enterprise DNA. I really liked the course. Its well explained, organized and importantly all the datas and formulas & even dashboards are available for everyone.”

Mahesh T, London

“Enterprise DNA has greatly increase my ability to report within our company forever. I went from knowing nothing about Power BI to using it on a daily basis in 30 days simply by watching Sam’s videos & executing his technique.”

Geoff Ellis

“Sam has a very hands-on approach to his training, and is always willing to help! Been apart of several different DAX classes, & Sam’s training is by far the best I have come across.”

Matt Ballinger

“I am really thankful to Sam for helping me through the Power BI. I was a newbie and his hands-on approach and business-oriented approach is all we need. Great work Sam. Keep going!”

Sourabh

“Thanks to Enterprise DNA training! I have improved my Power BI tool skills and have a deeper understanding of data analytics. Sam does an excellent job teaching and problem-solving.”

Brian Marron