How to create a table with columns and looked up values from different tables?

[Anonymous]

Hello

How to create a table with columns and looked up values from different tables?

I want to create a table with a specific column from a specific table and then do a VLOOKUP to another table in a specific column and return another specific column.

Thanks!

[V-lianl-msft]

Hi @Anonymous ,

You can learn more about "LOOKUPVALUE".

If the problem persists,could you please share sample data or sample pbix?

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

[amitchandak]

Refer: https://community.powerbi.com/t5/Desktop/Vlookup-from-Another-Table-Return-Value-from-Column/td-p/51...

LOOKUPVALUE( Table2[A1], Table2[Key], Table1[Key])  

Also you can get new column like

New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])

New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project]),table2[name])