Duplicated

[Tito]

I have a duplicate in the "Product" column. I want to have a new column without duplicates, the new column must look like this:
- If the sum of the number of each duplicate product is greater than 1, the new column must return the number 1 (For example: Product B : 0.3 + 1= 1.3 ==> 1).
- If the sum of the number of each product is less than 1, the new column must return the sum of the products (for example: product C : 0.2 + 0.6= 0.8 ==> 0.8).

Data:

 

Result:

 Thanks for your help

[AlienSx]

@Tito How to integrate M-code into your existing solution 

[AlienSx · Accepted solution]

Table.Group(your_table, "Product", {"Number", each List.Min({1, List.Sum(_[Number])})})

[Tito]

Hi @AlienSx  ,

Thank you very much, it worked.

I also have a question: What should I change in the code

- If the sum of the number of each duplicate product is greater than 1, the new column must return the number 1 (For example: Product B : 0.3 + 1= 1.3 ==> 1).

-If the sum of the numbers of each product is less than 1, the new column must return the maximum (for example: product C: 0.2 & 0.6 ==> 0.6).

Result:

 

[AlienSx]

@Tito 

Table.Group(
        your_table, "Product", 
        {"Number", each 
            if List.Sum([Number]) >= 1 then 1 else List.Max([Number])
        })

[Tito]

Hi @AlienSx 

Thank you very much. It has worked. Perfect 👏

[Tito]

HiAlienSx,

Thank you. I tried it, but I got the following error message:

Expression.Error: A cyclical reference was recognised during the evaluation.