I have two tables as this (example):
in table2 I want to lookup for the order number based on comparing the customer number and product number:
I tried something like this, but did not work:
If[custemer number] = tabel1(customer number) and [product number] = tabel1[product number], tabel1[order number], blank)
You can follow the steps below without writing any code.
1. Click table2, then click the meger queries button
2. Hold down ctrl and click the columns that need to be matched, then select the table table1 that needs to be matched below, then hold down ctrl and click the columns that need to be matched (note that the order of clicks must correspond to the previous columns), and then click the OK button.
3. expand the required columns
You can follow the steps below without writing any code.
1. Click table2, then click the meger queries button
2. Hold down ctrl and click the columns that need to be matched, then select the table table1 that needs to be matched below, then hold down ctrl and click the columns that need to be matched (note that the order of clicks must correspond to the previous columns), and then click the OK button.
3. expand the required columns
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Data Days 2026
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
