DAX

Share

Explore

DAX

Avec relation dans le modèle

LOOKUPVALUE
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]

)

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.