First value for lookupvalue

[bereteli]

Hi everybody. Help me plz. I have table with product range.  My goal is find first result from lookupvalue, but from the other colums for built PATH().

My example. 

Сomponent parts	Product	Code Product	ChildID
Zubr after test	Zubr	C-0000222	=LOOKUPVALUE([Code Product];[Product];[Component part])  it's will = > C-0000328
Zubr completing	Zubr after test	C-0000328	need  = > C-0000692
Power supply	Zubr completing	C-0000692	-
Power supply	Zubr completing	C-0000693

[v-diye-msft · Accepted solution]

Hi @bereteli 

You should probably refer to the firstnonblank function, please kindly check below thread:

https://community.powerbi.com/t5/Desktop/Lookupvalue-only-first-result/m-p/244009 

 https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-return-first-of-multiple-matches/m-p/727121