Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |