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.

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you! The measure worked!