Forum Discussion
Jalal_1988
Dec 14, 2023Brass Contributor
TOTAL AMONOUT FOR EACH COSTUMER
Hello my friends how I can achieve to the total amount for each costumer separately in one column like the excel fiea i shwed the table and the result which i want in power query, Thank you f...
- Dec 14, 2023
Hi Jalal_1988
First you do a double aggregation when Grouping [Customer]:
Then Expand all (but 'Customer') fields from [DATA] and add a custom [SHARE] column
Lorenzo
Dec 14, 2023Silver Contributor