Bring a value only once to a column with repeated values with lookupvalue

[Syndicate_Admin]

Good night

They could help me with the next problem

I want to find the values in the quantity column of table 2 and bring them only once to table 1, so the key is repeated.

""RESULT =LOOKUPVALUE (TABLE2[QUANTITY],TABLE2[SKU],TABLE1[SKU])""

this is what I hope

TABLA1
SKU	Product	RESULT
1234a	A1	10
1234a	A1	-
1234a	A1	-
5555c	B1	20
6666b	B2	30
7777d	B3	40

TABLA2
SKU	Quantity
1234a	10
5555c	20
6666b	30
7777d	40

Here's what it delivers

TABLA1
SKU	Product	RESULT
1234a	A1	10
1234a	A1	10
1234a	A1	10
5555c	B1	20
6666b	B2	30
7777d	B3	40

[v-stephen-msft · Accepted solution]

Hi @DADAZA1032 ,

Sorry for my missunderstanding, here I updated my reply.

1.Add an index column group by [Product] in Power Query. You can refer to the detailed steps:

How to create group index with Power Query or R - (example in Power BI) (datacornering.com)

And pay attention to convert the index column to number type.

2.Create a calculated column to get the results in Desktop.

RESULT = IF([Index]=1,RELATED(Table2[Quantity]))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.