Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Nbr Clients Stratégique =
CALCULATE(
DISTINCTCOUNT(unionFactureBon[ID_CLIENT]),
CLIENT[BOOL_STRATEGIQUE] = TRUE()
)
VAR unionFactureBon =
UNION(
SUMMARIZE(FACTURE_VENTE, FACTURE_VENTE[ID_CLIENT], FACTURE_VENTE[DATE_FACTURE]),
SUMMARIZE(FILTER(BON_LIVRAISON, ISBLANK(BON_LIVRAISON[DATE_FACTURE])),
BON_LIVRAISON[ID_CLIENT], BLANK())
)
Solved! Go to Solution.
Your syntax is the wrong way round
Table =
var tempvariable = something
return union(tempvariable, tempvariable)
Your syntax is the wrong way round
Table =
var tempvariable = something
return union(tempvariable, tempvariable)
Check out the November 2023 Power BI update to learn about new features.