Compare 2 tables

[MasterSonic]

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 · Accepted solution]

@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