Solved: Compare 2 tables

MasterSonic · ‎08-18-2022

Hi Guys

is power bi a tool that would help compering 2 tables?

First - column names are not matching but this could be mapped during loading excels into power bi

What about conditions - If Table1 column "Alfa" has value Batch and Table2 column "Alfa" is blank then FALSE

what would you recommend to use? cal.columns, measurments? Table3 with results?

Thanks for any ideas

Fowmy · ‎08-18-2022

@MasterSonic

You can use multipl ways. IF you have a common key in these two tables then, you can add a calculated column using LOOKUP function.

Or, in Power Query, perform a table merge,

If you no common keys are there, then you need to rely on the position of the rows as it is. Add and index column in both the tables and merge then add additional columns to check

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Fowmy · ‎08-18-2022

@MasterSonic

You can use multipl ways. IF you have a common key in these two tables then, you can add a calculated column using LOOKUP function.

Or, in Power Query, perform a table merge,

If you no common keys are there, then you need to rely on the position of the rows as it is. Add and index column in both the tables and merge then add additional columns to check

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group