Forum Discussion
JonathanJohns
Helper III
Helper IIIMerge 2 tables with Power BI Desktop
Good afternoon everyone, I am trying to merge two tables with Power BI but I don't find the way to do. The tables are from 2 Excel files. They have some similar columns but not all of them a...
I used the function Add a new request in the Editor to do it. It is fast and it works properly ! :)
Thank you for your help.
Regards,
v-sihou-msft
Microsoft Employee
Microsoft Employee
In this scenario, you want to find the match Weight based multiple column values, so you should use LOOKUPVALUE() function.
=
LOOKUPVALUE (
Table2[Weight],
Table2[Lot], Table1[Lot],
Table2[Date], Table1[Date],
Table2[pH], Table1[pH]
)
Regards,
JonathanJohnsHelper III
Helper IIII used the function Add a new request in the Editor to do it. It is fast and it works properly ! :)
Thank you for your help.
Regards,