Skip to content
Home » POWER BI » POWER BI DAX

POWER BI DAX

Data Analysis Expression (DAX), According to Microsoft Documentation DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model




Export Power BI Measures and Calculated Columns

Filter Functions

ALL

CALCULATETABLE

SELECTEDVALUE

FILTER

REMOVEFILTERS

LOOKUPVALUE

Math and Trig Functions

SUM

SUMX

DIVIDE

TRUNC

Logical Functions

IF

SWITCH

COALESCE

IFERROR

Statistical Functions

COUNT

Date and Time Functions

DATE

CALENDARAUTO

EOMONTH

Text Functions

LEN

UNICHAR

REPT

REPLACE

SUBSTITUE

CONCATENATEX

FIND

FORMAT

MID

UPPER

LOWER

Information Functions

CONTAINS

ISBLANK

Table Manipulation Functions

SUMMARIZE

SUMMARIZECOLUMNS

VALUES

DATATABLE

ADDCOLUMNS

GENERATESERIES

TOPN

Relationship Functions

RELATED

USERRELATIONSHIP

Time intelligence Function

SAMEPERIODLASTYEAR

TOTALYTD

LASTNONBLANK

OPENINGBALANCEMONTH

CLOSINGBALANCEMONTH

Parent and Child Function

PATH

PATHLENGTH

PATHITEM

PATHREVERSE




Also Read..

Create Power BI Reports

 4,463 total views,  4 views today