Forum Discussion

Hgoonetilleke's avatar
Hgoonetilleke
Regular Visitor
3 years ago
Solved

mapping data in multiple columns from another table

Hi All,   I am trying to map the equipment name from Table B to Table A   See short example below, however the data file im actually using will have 10000+ rows   Table A Equipment ID Equi...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Hgoonetilleke 

     

    You can try the following methods.
    Tbale B: Transform-Unpivot Other Columns

    Then

    Result:

    Column:

    Equipment Name = 
CALCULATE ( MAX ( 'Table B'[Equipment Name] ),
    FILTER ( 'Table B', [Value] = EARLIER ( 'Table A'[Equipment Tag] ) )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Hgoonetilleke 

 

You can try the following methods.
Tbale B: Transform-Unpivot Other Columns

Then

Result:

Column:

Equipment Name = 
CALCULATE ( MAX ( 'Table B'[Equipment Name] ),
    FILTER ( 'Table B', [Value] = EARLIER ( 'Table A'[Equipment Tag] ) )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

Hgoonetilleke's avatar
Hgoonetilleke
Regular Visitor
3 years ago

Thank you