In PowerQuery I try to sum the `quantité livrée`by `BL 2` (i have several rows with the same BL2 number but i can't delete doublons, regarding of details of the data)
The data looks like:
I tried:
=Table.Group(#"Somme quantité livrée", {"BL 2"},{{"quantité livrée", each List.Sum([#"quantitée livrée"]), type number}}
but the function doesnt work, have the same error message "`RightParen token excepted"` but i don't see what should i do here (or even if its the right function to do what i except)
Basically i want to obtain the sum of the `quantité livrée`, `quantité retournée`, `quantité facturée` by distinct `BL 2`
Any idea?
Hey @Anonymous ,
Looks like you're missing the right parenthesis at the end of the function.
= Table.Group(#"Changed Type", {"BL 2"},{{"quantité livrée", each List.Sum([#"quantité livrée"]), type number}})Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
Proud to be a Super User!
Hey @Anonymous ,
Looks like you're missing the right parenthesis at the end of the function.
= Table.Group(#"Changed Type", {"BL 2"},{{"quantité livrée", each List.Sum([#"quantité livrée"]), type number}})Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
Proud to be a Super User!
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
