Forum Discussion

ecs70206's avatar
ecs70206
Regular Visitor
9 years ago
Solved

Identify duplicates between two tables

Good evening,   i've come across a problem im hoping someone can help with.   I have two excel spreadsheets loaded into pBI - one contains journey information (Pupils Current) and the other one f...
  • GilbertQ's avatar
    9 years ago
    Hi there

    If you have created a relationship and you put in a table the values from your table where you have all the journey;s.

    And then create a slicer from your second table that has the missing values, is that the slicer will have a BLANK option. So if you click on the BLANK it should then show you the values in your first table that do not have any matching rows.