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.⚡

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

You can use an expression like this in your calculated column to get your desired result.  FYI that you will not be able to have two columns with same name, so I am changing to ID2 for your second ID column:

 

Lookup Group =
VAR __thisID2 = Table[ID2]
RETURN
    CALCULATE ( AVERAGE ( Table[Group] ), ALL ( Table ), Table[ID] = __thisID2 )

 

Not sure if you have multiples rows, so I used average, but if single row for each Min, Max, Sum would also work.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat