Forum Discussion
Lookup value from same table
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.⚡
Hi Anonymous
If [Group] has number and text type data, please change the formula from mahoneypat as below:
Lookup Group =
VAR __thisID2 = Table[ID2]
RETURN
CALCULATE ( MAX( Table[Group] ), FILTER(Table ,Table[ID] = __thisID2 ))Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- i wish to be have in query editor
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.⚡
Thank you! Why does this work?! I have been trying to solve a similar problem like this:
Lookup Group =
VAR __thisID2 = Table[ID2]
RETURN
CALCULATE ( MAX( Table[Group] ), Table[ID] = __thisID2 )
and it never worked. Thank you and also I would love to understand why this makes a difference if you know it!
