DAX
Share
Explore
Principes du DAX

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
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.