Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Lookup value from same table

Hi    i wish to be have  Group Values according to ID values in power query Second ID has some values from First ID columns   Sample Data   Please guide & help
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous solution attached using power query.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous sorry your question is not clear, can you be more specific, what output you are looking for.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    yelllow highlighted column has first column values and i wish to have values from Group column in new column which refer the yellow highlighted ID values i. e. 

    ID  Center  Group   ID Results

    1        2         30       2     65

    3         4        50      5      55

    2        5         65      4      50

    5         1         55     1      30

     

    like a vlookup in excel

     

    Like this 

     

     

    Hope i am clear on my query,