Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I would like to merge two table but i need to look at mutile column to see if I have a match.
the goal is to find if there is a match in the column IP1 then IP2,IP3... in each of the other table IP column.
and if possible add plus one on the number of matches
table 1:
Name | IP1 | IP2 | IP3 | IP4 | IP5
table 2:
Depatement | IP1 | IP2 | IP3 | IP4 | IP5
merge table:
Name| Depatement | IP1 | IP2 | IP3 | IP4 | IP5| Number of matches
Do you have any idea now I can proceed in Power Query?
Thank you very much
Solved! Go to Solution.
You can merge in Power Query on multiple fields. Just CTRL-Click the 2nd-Nth fields on both tables in the same order. Little numbers will show up to show you which columns will join based on which.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou can merge in Power Query on multiple fields. Just CTRL-Click the 2nd-Nth fields on both tables in the same order. Little numbers will show up to show you which columns will join based on which.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting