How to compare two table column values in power bi?

[Anonymous]

I'm comparing the two tables .Policy number is the unique.

Table A:

Status  Type    Date        PolicyNo
PS      T607    01-01-2020  1002
PS      T608    02-01-2020  1003
CF      T646    03-01-2020  1004
PS      T607    04-01-2020  1005

Table B:

Status  Type    Date        PolicyNo
PS      T607    01-01-2020  1002
PS      T608    02-01-2020  1003
CF      T645    03-01-2020  1004
PS      T607    04-01-2020  1005

and conditions are

1) If both table values have same PolicyNo(1002), day, status(PS/CF), transaction id(T607 && T608) ((both tables should match)) then I have to ignore otherwise consider and find which column is have mismatch.

[DataInsights · Accepted solution]

@Anonymous,

Try this calculated table:

TableA_vs_TableB = 
VAR vTableAExceptB =
    EXCEPT ( TableA, TableB )
VAR vTableBExceptA =
    EXCEPT ( TableB, TableA )
VAR vResult =
    UNION ( vTableAExceptB, vTableBExceptA )
RETURN
    vResult

[PaulDBrown]

@Anonymous 

Just as an addition to @DataInsights solution, you can use this as a measure by simply adding COUNTROWS as the first function of the RETURN expression and use this as in the filter pane and setting the value to 2 or greater for a table visual