Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matching Columns in 2 Tables

Hi everyone!   New PBI user here 🙂 I have a table that has different codes related to dates they were inputted, and I have another table that has those codes and what each code means:   Table...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario. It works propperly on my side. The pbix file is attached in the end.

     

    Table1:

     

    Table2:

     

    There is a relationship between two tables.

    Result:

     

    You may also create a measure as below.

    Meaning Measure = 
MAXX(
    FILTER(
        ALL(Table2),
        Table2[Code]=SELECTEDVALUE(Table1[Code])
    ),
    [Meaning]
)

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HotChilli's avatar
HotChilli
Community Champion
6 years ago

None of them match up or just some?

 

Check for the same data type in both tables.

Check for spaces or other hidden characters.

You can clean the data in Power Query using Trim or Clean