Forum Discussion
Helper IIICompare two tables' data in power BI
Hi,
I have two tables, we neeed to compare two tables data matching between two tables and not matching data them in power bi .
User should able to understand the match data between two tables and not matching data in single table visual in power bi.
Table1:
Table2:
Note: in model part when we connect two table we can do only many-many relationship.
Does any one have worked on such kind of scenario?
Thanks,
SBC
Hi ,
above requirement get fullfilled by using full outer join and applying conditional column in the power query.
for reference please go through below links:
Link1: Solved: Re: Compare columns based on two different table - Microsoft Power BI Community
Thanks,
SBC
2 Replies
Waldo35Helper I
I am not sure i understand the question entirely, but i hope i did otherwise you can let me know.
My table 1
My table2
hereby making profit number on row 4 different.
Then the table which looks for non matching rows:
In this case keeping the profit_number of table2. But of course if not needed you could take table1.
Formula
= Table.RemoveMatchingRows(Table2, Table.ToRecords( Table1))
SBCHi ,
above requirement get fullfilled by using full outer join and applying conditional column in the power query.
for reference please go through below links:
Link1: Solved: Re: Compare columns based on two different table - Microsoft Power BI Community
Thanks,
SBC