How to LOOKUPVALUE in PowerQuery?

Hi sophie23 

Use Merge Queies to create a new table with all Rows from TableA and the Exchange Rate from TableB where the date and Currency match.  Where's there's no match you'll get a null.

In the Merge dialog box you want to choose the Join Kind : Left Outer

Regards

Phil

Hi sophie23 ,

Please refer to this example:

---

 

(let currentCustomer = [CustomerName] in Table.SelectRows(Table1, each [CustomerName] = currentCustomer)){0}[CustomerID]

 

Reference: Solved: How to lookup values in another table in the Query... - Microsoft Power BI Community

 

---

Best Regards,

Icey

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