Forum Discussion
Solved
Derive LOOKUPVALUE dax
Team,
how can i achieve the Parent Column in below example. Tried Lookup value, but since there is a duplicate value in Column C, i cannot derive it. Also, look at the row 4 (Computer) which does not have any parent. This shold also be handled. Can anyone help please?
| A | B | C | Parent - it’s a Dax driven Column |
| 1 | Apple | 5 | Fruits |
| 2 | Orange | 5 | Fruits |
| 3 | Banana | 5 | Fruits |
| 4 | Computer | 5 | |
| 5 | Fruits | 5 | Fruits |
| 6 | Tomato | 10 | Vegetables |
| 7 | Onion | 10 | Vegetables |
| 8 | Cabbage | 10 | Vegetables |
| 9 | Brocolli | 10 | Vegetables |
| 10 | Vegetables | 10 | Vegetables |
koushikvps this is a duplicate of this post(https://community.powerbi.com/t5/Desktop/Help-needed-on-Lookup-value-function/m-p/486552#M226619)
can you please delete it. I have posted the answer in the above post.
1 Reply
koushikvps this is a duplicate of this post(https://community.powerbi.com/t5/Desktop/Help-needed-on-Lookup-value-function/m-p/486552#M226619)
can you please delete it. I have posted the answer in the above post.