Forum Discussion

michellepace's avatar
michellepace
Icon for Resolver III rankResolver III
7 years ago
Solved

Create a column based on a lookup in another table

Hi, I've spent the last hour trying to understand this and google around. I must be missing something completely because it simply cannot be that difficult. Alright, I have the below two tables:   ...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi michellepace,

    You could try below

    Column = LOOKUPVALUE('Table2'[AccNumber],'Table2'[AccNumber],'Table 1'[AccNumber])*1000

    Best Regards,
    Zoe Zhi

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

  • michellepace's avatar
    michellepace
    6 years ago

    Hi, it's amazing how I can make something so simple so complicated :). The RELATED function worked for me. Just posting this pic here for anyone else who may find it useful. 

     

michellepace's avatar
michellepace
Icon for Resolver III rankResolver III
6 years ago

Hi, it's amazing how I can make something so simple so complicated :). The RELATED function worked for me. Just posting this pic here for anyone else who may find it useful. 

 

HelenaX's avatar
HelenaX
Icon for Helper I rankHelper I
5 years ago

Thank you! So helpful!!