how to compare multiple columns from two tables in power bi ( is there any mdc or hash function key)

[RUPSY777]

how to compare multiple columns from two tables in power bi ( is there any mdc or hash function key)?- i am doing a reconcillation where i am checking and comparing multiple columns using conditional column but is there any easy way or can we use hash key ?

[camargos88]

Hi @RUPSY777 ,

You can do it by merging with FULL OUTER if you have a key on both tables.

Ricardo

[edhans]

You can combine multiple columns in each table, then compare the combined colums to each other. There is no hash function though.

Not sure what you are doing though. You might be able to use an Anti-Merge to see what items don't exist in table a vs table b.

[RUPSY777]

i have already used a merge function to merge two tables ( primary and secondary table with left outer join - all rows from first and matching frm second). Then i started doing conditional column when we compare the columns. now i need a final column which will say if anything is not matched it should show but when i using final check column - its showing one value /either match or not matched - its not showing specfic values row wise.

Final column:

if [ID Check]="Match" and [Project name check]="Match"
and [Level 1 Function Check]="Match" and [Level 2 Function check]="Match" and [Fiscal check]="Match" then 1 else 0

[edhans]

Data would definitely help us out here.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

[RUPSY777]

i am not able to the total check as its showing all false or all True .

[edhans]

Can you follow the links I provided? I'm not typing that in.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum