Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])""
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 |
Solved! Go to 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.
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.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |