DAX Functions in Power BI
Carl Rosseel
Curriculum Manager
Implicit
Sales
to values of a table, Power BI will automatically sum itExplicit
Total Sales = SUM(Orders[Sales])
Total Sales = SUM(Orders[Sales])
Total Sales
is more clear than Sales
(SUM, AVG, MIN, ... ?)Total Sales East = CALCULATE([Total Sales],Orders[Region] = 'East')
Can be used as an argument to other measure expressions
Four main advantages:
Syntax:
VAR <name> = <expression>
RETURN
statementVAR
SALESPRIORYEAR = CALCULATE([SALES],SAMEPERIODLASTYEAR('DATE'))
RETURN
Sales growth = [Sales] - SALESPRIORYEAR
Sales growth =
VAR
SALESPRIORYEAR = CALCULATE([SALES],SAMEPERIODLASTYEAR('DATE'))
RETURN
Sales growth = [Sales] - SALESPRIORYEAR
DAX Functions in Power BI