Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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}})
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}})
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.