How can i refer the data in table 1 to table 2

[daydream1989]

table 1table 2Hi, I have two tables in Power BI, table 1 is a reference table that shows document type and the document type description, while table 2 is a list of transactions, which only shows the document type. How can i create a column in table 2 and do something like 'vlookup' the document type in table 1 and show toe document type description in table 2? Please help. 

[AKNiang · Accepted solution]

Hi,

You have to create a calculated column.

Use the function LOOKUP:

The syntax is easy.

LOOKUPVALUE(
<result_columnName>,
<search_columnName>,
<search_value>,
 <alternateResult>] )

✅ Consider to mark this question as solved

My LinkedIn profile: Abdoul Karim Niang | LinkedIn

[daydream1989]

It works. Thanks!

[ryan_mayu]

@daydream1989 

you can try merge tables in pq

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

or you can use lookupvalue or related

RELATED function (DAX) - DAX | Microsoft Learn

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn