DAX Functions

in Power BI Desktop
❖ DAX functions can supercharge your analytics game.
Every DAX function applies a specific operation to the
values in an argument. In a DAX formula, you can
specify several arguments.
Aggregation Date & Time
Filter functions
functions functions

Financial Information Logical

functions functions functions

Math & Trig Parent & Child

Other functions
functions functions

Relationship Statistical
Text functions
functions functions

Time Table
New DAX
intelligence manipulation
Functions
functions functions

Naveen Billa
 Aggregation
Functions
SUM

COUNT

AVERAGE

MIN

MAX

PRODUCT
➢ These functions perform
calculations on columns or SUMX
expressions to summarize data.
COUNTA

COUNTROWS

DISTINCTCOUNT

Naveen Billa
 Date & Time
Functions
TODAY

YEAR

QUARTER

DATE

DATEDIFF

EOMONTH
➢ These functions help you create
calculations based on dates and UTCNOW
time.
WEEKDAY

DATEDIFF

CALENDARAUTO

Naveen Billa
 Filter
Functions
FILTER

ALL

ALLSELECTED

ALLEXCEPT

SELECTEDVALUE

KEEPFILTERS
➢ These functions allow you to filter
and manipulate tables or columns CALCULATE
based on specific conditions. INDEX

LOOKUPVALUE

RANK

Naveen Billa
 Financial
Functions
DURATION

MDURATION

RATE

PRICE

YIELD

➢ Financial functions in DAX are DISC

used in formulas that perform
EFFECT
financial calculations, such as
net present value and rate of INTRATE
return. ISPMT

NOMINAL

Naveen Billa
 Information
Functions
ISBLANK

CONTAINS

ISFILTERED

ISONORAFTER

HASONEVALUE
➢ These functions provide USERPRINCIPALNAME
information about data and
calculations. USERNAME

ISERROR

ISTEXT

HASONEFILTER

Naveen Billa
 Logical
Functions
IF

SWITCH

OR

AND

NOT

➢ Logical functions act upon an IFERROR

expression to return
TRUE
information about the values
or sets in the expression. FALSE

COALESCE

IF.EAGER

Naveen Billa
 Math & Trig
Functions
ABS

ROUND

CEILING

DIVIDE

CURRENCY

➢ Math and Trig DAX functions FLOOR

are used for performing a wide
SQRT
range of mathematical and
trigonometric calculations. POWER

CONVERT

DEGREES

Naveen Billa
 Other
Functions

BLANK

ERROR
➢ These functions perform
unique actions that cannot be TOCSV
defined by any of the
categories.
TOJSON

Naveen Billa
 Parent & Child
Functions

PATH

PATHCONTAINS
➢ Parent and Child functions
PATHITEM
are used in DAX to navigate
and work with hierarchical PATHITEMREVERSE
data structures like parent-
child hierarchies. PATHLENGTH

Naveen Billa
 Relationship
Functions

CROSSFILTER

RELATED
➢ Functions in this category are
for managing and utilizing RELATEDTABLE
relationships between tables.

USERELATIONSHIP

Naveen Billa
 Statistical
Functions
RANKX

STDEV.P

VAR.S

NORM.DIST

COMBIN
➢ These functions help you to
MEDIAN
calculate values related to
statistical distributions and GEOMEAN
probability, such as standard CONFIDENCE.T
deviation and number of
EXPON.DIST
permutations.
LINEST

Naveen Billa
 Table Manipulation
Functions
SUMMARIZE

ADDCOLUMNS

CROSSJOIN

VALUES

TOPN
➢ These functions create, UNION
manipulate, or summarize
tables. TREATAS

EXCEPT

GROUPBY

INTERSECT

Naveen Billa
 Text
Functions
FORMAT

CONCATENATEX

LEFT

SEARCH

FIND
➢ These functions work with text EXACT
data, such as manipulating
strings. REPLACE

SUBSTITUTE

TRIM

UNICHAR

Naveen Billa
 Time Intelligence
Functions
TOTALYTD

DATEADD

SAMEPERIODLASTYEAR

PARALLELPERIOD

PREVIOUSYEAR
➢ These functions are used for
DATEMTD
analyzing and comparing data
over time periods. DATESINPERIOD

LASTDATE

STARTOFMONTH

ENDOFYEAR
Naveen Billa
 New DAX
Functions

NETWORKDAYS

MATCHBY

RANK
➢ DAX is continuously being
improved with new functions ROWNUMBER
and functionality to support
LINEST
new features.
INDEX

Naveen Billa