Forum Discussion

mabCOLONEL's avatar
mabCOLONEL
Frequent Visitor
3 years ago
Solved

Index match custom column from seperate table

I have two tables.  Table A has a column to tag certain rows so I can filter them out of matrix results.  However, I already have a relationship built between the two tables.  So I want this column o...
Need Help
  • mabCOLONEL's avatar
    mabCOLONEL
    3 years ago

    Hi rsbin ,
    I ended up just merging from Table A into Table B.  I messed around until I figured out the need to 'expand' Table A once merged.  It was rather simple as I only really needed the one column.  

     

    I have a feeling some of my tables migh have an issue as many of them will not 'stick' as values in a matrix and the majority of measures I attempt return invalid identifiers.  However, when I build the visuals from a seperate report and paste them in, they work fine. 

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
3 years ago

mabCOLONEL ,

My test shows that the LOOKUPVALUE function should work:

LookupTest = LOOKUPVALUE( Lookup[Status], Lookup[Location ID], [ID], Lookup[Customer ID], [Customer ID]  )

Please ensure your ID column is the same format in both tables - ie. either Text or Number.

If still not working, please show the error message your LookupValue is giving.

Regards,

mabCOLONEL's avatar
mabCOLONEL
Frequent Visitor
3 years ago

Hi rsbin ,
I ended up just merging from Table A into Table B.  I messed around until I figured out the need to 'expand' Table A once merged.  It was rather simple as I only really needed the one column.  

 

I have a feeling some of my tables migh have an issue as many of them will not 'stick' as values in a matrix and the majority of measures I attempt return invalid identifiers.  However, when I build the visuals from a seperate report and paste them in, they work fine.