Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
pls try this
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |