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.
Data:
Each 'Code' has multiple 'Amount' in a month. E.g. 1001 has two entries of 10 and 20 on 31st January.
Code | Date | Amount |
1001 | 31/1/19 | 10 |
1001 | 31/1/19 | 20 |
1001 | 28/2/19 | 15 |
1001 | 28/2/19 | 25 |
1002 | 31/1/19 | 30 |
1002 | 31/1/19 | 40 |
1002 | 28/2/19 | 15 |
1002 | 28/2/19 | 25 |
Requirement:
I want to make my data unique on the basis of 'Code' and 'Date' so that each 'Code' has one entry for each 'Date' and the 'Amount' is totalled up into a new column 'SubTotal'
Code | Date | SubTotal |
1001 | 31/1/19 | 30 |
1001 | 28/2/19 | 40 |
1002 | 31/1/19 | 70 |
1002 | 28/2/19 | 40 |
I need to do this in Power Query.
Thank you!
Solved! Go to Solution.
hi @danialsj
that's pretty much easy
right click on the Code field. then "Group by" then Advanced then Add grouping and Sum of Amount as new column. like this
do not hesitate to give a kudo to useful posts and mark solutions as solution
hi @danialsj
that's pretty much easy
right click on the Code field. then "Group by" then Advanced then Add grouping and Sum of Amount as new column. like this
do not hesitate to give a kudo to useful posts and mark solutions as solution
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.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |