Support Formation DAX
Avec relation dans le modèle

icon picker
LOOKUPVALUE


LOOKUPVALUE(
<result_columnName>,
<search_columnName>,
<search_value>
[, <search2_columnName>, <search2_value>]…
[, <alternateResult>]
)
Recherche la <search_value> dans la colonne <search_columnName> et retourne <result_columnName> quand trouvé, sinon <alternateResult>.
Exemple :
CHANNEL =
LOOKUPVALUE(
'Sales Order'[Channel],
'Sales Order'[SalesOrderLineKey],
[SalesOrderLineKey]
)
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.