Want to fetch field id from table2 which has no relationship with table1

[MKumar_17]

Hi,

I want to bring customer_id values from customers table into orders table. I am using lookupvalue which is showin error. added snapshot below. Since there is no relationship in two tables , I am using lookupvalues. Added workbook as well.

link for pbixhttps://github.com/mohitkumar-Tyagi/xyz/blob/main/Fetch_customerid.pbix :

Thanks!

[MKumar_17]

@amitchandak  thanks!

[lbendlin]

Read about TREATAS.  Unlearn LOOKUPVALUE if you can.

[MKumar_17]

@lbendlin  sure, thanks!

[MKumar_17]

@lbendlin  sure, thanks!

[amitchandak · Accepted solution]

@MKumar_17 , You can try a new column like

Maxx(filter(customer,customer[Customer Name] = Order[Customer Name]) , Customer[Customer ID])

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8