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.
Hi
I want to produce a table with SUM values. My data looks something like this:
Current data:
Code | Year | Type | Amount |
A | 2013 | Type 1 | 10 |
A | 2013 | Type 1 | 20 |
A | 2013 | Type 2 | 1 |
A | 2013 | Type 2 | 2 |
A | 2014 | Type 1 | 40 |
A | 2014 | Type 2 | 4 |
A | 2015 | Type 1 | 35 |
A | 2015 | Type 2 | 3 |
B | 2014 | Type 1 | 5 |
B | 2014 | Type 1 | 10 |
B | 2014 | Type 1 | 20 |
B | 2014 | Type 2 | 100 |
B | 2014 | Type 2 | 200 |
B | 2014 | Type 2 | 150 |
B | 2015 | Type 1 | 50 |
B | 2015 | Type 2 | 300 |
Table I want to produce:
Code | Year | Type 1 Sum |
A | 2013 | 30 |
A | 2014 | 40 |
A | 2015 | 35 |
B | 2014 | 35 |
B | 2015 | 50 |
As you can see, I want the sum of [Amount] filtered by [Type], grouped by [Code] and [Year].
I have tried a few different formulas, but can't get anything to work.
Any help appreciated!
Solved! Go to Solution.
@bullius Go to power bi desktop query editor, under Transform tab click Group by and apply it as shown below.
@bullius Go to power bi desktop query editor, under Transform tab click Group by and apply it as shown below.
That works, thanks!
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |