lookupvalue

[powerbiexpert22]

how to use lookupvalue function in power query? i am using direct query and cannot create calculated column

[v-xingshen-msft]

Hi @powerbiexpert22 ,

Has your problem been solved after all this time, or has a new problem arisen, if there are any other questions on this issue, feel free to contact me and I'll get back to you as soon as I receive the message.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xingshen-msft · Accepted solution]

Hi All,
Firstly  audreygerred thank you for your solution!
@powerbiexpert22 as you can imagine, there is actually no direct function in Power Query like the LOOKUPVALUE function in DAX, however, you can achieve LOOKUPVALUE-like functionality by using a merge query, and the following is an application that has a merge query.

If you use it in direct query mode, it will do this merge process by querying the database.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[audreygerred]

Hi! In Power Query, you should be able to do a merge to bring in fields that you want from one table to another. Even in import mode you should only use a calculated column as a last resort - you always want to add columns as far upstream as possible.