Derive LOOKUPVALUE dax

[koushikvps]

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

[Anonymous · Accepted solution]

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