DAX
Share
Explore
DAX
Principes du DAX

icon picker
Saisir du DAX (Excel, Power BI)

Excel

A partir de Power Pivot.

Power BI

Mesure =
VAR NomVariable = CalculDAX
RETURN
CalculDAXAvecVariable
Aussi :
FirstDaySales =
SUMX (
'Product',
VAR FirstSale = CALCULATE ( MIN ( Sales[Order data] ) )
RETURN
CALCULATE (
[Sales Amount],
'Date'[Date]= FirstSale
)

DAX Studio

DEFINE
VAR NomVariable = CalculDAX
EVALUATE
CalculDAXAvecVariable


DEFINE
MESURE Table[NomMesure] =
VAR NomVariable = CalculDAX
RETURN
CalculDAX
EVALUATE
CalculDAXAvecVariable
NomMesure s’utilise sans le nom de la table.

Valeurs littérales

Scale = { 1, 1000, 1000000 }
⁠
image.png
⁠
⁠
Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.