Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Retrieve Multiple Columns From Another Table

Hello Power BI community, I hope everyone doing well. Currently I am working on a table which I need to add couple of columns from another table. I managed to retrieve one column based on filter con...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi  Anonymous ,

 

You could use lookupvalue function to realize it.

Syntax:

 

LOOKUPVALUE(
    <result_columnName>,
    <search_columnName>,
    <search_value>
    [, <search2_columnName>, <search2_value>]…
    [, <alternateResult>]
)

 

Check here for more details.

Also check below blog for reference:

https://www.c-sharpcorner.com/article/dax-in-power-bi-how-to-use-lookupvalue-function/

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you! Missed that functionality of Lookupvalue().