Forum Discussion

Gerbil's avatar
Gerbil
Icon for Helper I rankHelper I
2 years ago

Make a Table that Shows Mismatched Data?

Hi All,   So I have two tables that look like this: ID Lat A Long A 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8   ID Lat B Long B 1 1...
Need Help
devesh_gupta's avatar
devesh_gupta
Icon for Impactful Individual rankImpactful Individual
2 years ago

Gerbil 

You can achieve this by merging the two tables and then creating a new column that checks for mismatches.

  1. Merge the Tables: In Power Query, merge the two tables using the ‘ID’ column as the key .

  2. Create a New Column: After merging, create a new column in Power BI to check for mismatches. You can use an IF statement to compare the ‘Lat’ and ‘Long’ values from both tables. Here’s an example of how you might do this: 

 

NewColumn = IF(Table1[Lat A] <> Table1[Lat B] OR Table1[Long A] <> Table1[Long B], "Mismatch", "Match")

 

  • Filter the Mismatches: Now, you can filter the table on this new column to only show rows where there is a mismatch.

If you find this insightful, please provide a Kudo and accept this as a solution.