Forum Discussion

DanielOtero's avatar
DanielOtero
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Solved

vlookup type relationship

I have two source tables that share Interal Order to tie them together. The first table (called InternalOrder) has all 500K in our ecosystem, whereas the second table (IO Used Table...) has a subset o...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi, DanielOtero

     

    In the table that has all 500K, new a calculated column using the formula like below:

     

    NewColumn = LOOKUPVALUE(Table_100K[Value],Table_100K[Category],Table_500K[category])

     

    Best regards,
    Yuliana Gu

     

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi, DanielOtero

 

In the table that has all 500K, new a calculated column using the formula like below:

 

NewColumn = LOOKUPVALUE(Table_100K[Value],Table_100K[Category],Table_500K[category])

 

Best regards,
Yuliana Gu