Forum Discussion
Solved
Sum a Column by Several Filters
Hey all,
I'm trying to sum a column (amount) filtering by 3 other columns, see below
| supplier | grouping | year | amount | New Column |
| a | 1 | 22 | 5 | 15 |
| a | 1 | 22 | 10 | 15 |
| a | 1 | 23 | 10 | 10 |
| a | 2 | 23 | 15 | 15 |
| b | 1 | 22 | 12 | 12 |
| b | 1 | 23 | 3 | 3 |
| b | 2 | 22 | 5 | 15 |
| b | 2 | 22 | 10 | 15 |
| b | 3 | 23 | 20 | 20 |
The New column is what I am trying to calculate in Power Bi
Help would be much appreciated, if you need anymore info let me know.
Thanks
Nathan
pls try this
1 Reply
pls try this