Forum Discussion

rdstone230's avatar
rdstone230
Regular Visitor
3 years ago
Solved

Filter matched unique values

Hi - I have two tables where both tables contain a column with a unique ID number.  Table 1 will contain a single or mutiple value of a unique ID number while table 2 will contain multiple values of ...
  • rdstone230's avatar
    rdstone230
    3 years ago

    Thank you tamerj1 

    My apologies for the insufficent information.  It speaks to my inexperience.

    It took time, but I learned to use a 'LOOKUP' with the help of resources found at Power BI documentation - Power BI | Microsoft Learn  I then filtered on only the 'blank' matches resulting in a solution.  I really appreciate your time and, thank you again.

     
    Rescheduled Shipments =
    LOOKUPVALUE (
            'Table1' [Truck ID], 'Table1 '[Truck ID], 'Table2 [Truck ID]
    )
rdstone230's avatar
rdstone230
Regular Visitor
3 years ago

Thank you tamerj1 

My apologies for the insufficent information.  It speaks to my inexperience.

It took time, but I learned to use a 'LOOKUP' with the help of resources found at Power BI documentation - Power BI | Microsoft Learn  I then filtered on only the 'blank' matches resulting in a solution.  I really appreciate your time and, thank you again.

 
Rescheduled Shipments =
LOOKUPVALUE (
        'Table1' [Truck ID], 'Table1 '[Truck ID], 'Table2 [Truck ID]
)