Forum Discussion

Tito's avatar
Tito
Helper IV
2 years ago
Solved

Duplicated

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...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
    Table.Group(your_table, "Product", {"Number", each List.Min({1, List.Sum(_[Number])})})
AlienSx's avatar
AlienSx
Super User
2 years ago
Table.Group(your_table, "Product", {"Number", each List.Min({1, List.Sum(_[Number])})})
Tito's avatar
Tito
Helper IV
2 years ago

HiAlienSx,

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

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