Forum Discussion
Solved
Rank in Power Query
Hello, I Have a list of Store Number, Interval (time), and totalcallsAnswered. I'd like to use Power query to rank from highest call volume to lowest call volume within each store. Please see desired column below. I see there is a rank column feature but it's in preview?
| STORENBR | Interval | TotCallsAnswered | Desired Result |
| 10002 | 12:00 | 341 | 1 |
| 10002 | 13:30 | 288 | 2 |
| 10002 | 16:30 | 278 | 3 |
| 10002 | 12:30 | 277 | 4 |
| 10002 | 13:00 | 272 | 5 |
| 10002 | 11:00 | 269 | 6 |
| 10002 | 11:30 | 269 | 7 |
| 10002 | 14:00 | 265 | 8 |
| 10002 | 15:00 | 261 | 9 |
| 10002 | 16:00 | 260 | 10 |
| 10002 | 17:30 | 257 | 11 |
| 10002 | 17:00 | 254 | 12 |
| 10002 | 18:00 | 221 | 13 |
| 10002 | 14:30 | 218 | 14 |
| 10002 | 18:30 | 207 | 15 |
| 10002 | 15:30 | 177 | 16 |
| 10002 | 19:00 | 154 | 17 |
| 10002 | 19:30 | 119 | 18 |
| 10002 | 10:30 | 110 | 19 |
| 10002 | 20:00 | 101 | 20 |
| 10002 | 20:30 | 79 | 21 |
| 10002 | 10:00 | 71 | 22 |
| 10002 | 21:00 | 60 | 23 |
| 10002 | 21:30 | 37 | 24 |
| 10002 | 9:30 | 0 | 25 |
| 10007 | 14:00 | 249 | 1 |
| 10007 | 11:00 | 223 | 2 |
| 10007 | 10:00 | 221 | 3 |
| 10007 | 9:30 | 219 | 4 |
| 10007 | 15:00 | 213 | 5 |
| 10007 | 9:00 | 208 | 6 |
| 10007 | 10:30 | 188 | 7 |
| 10007 | 12:00 | 187 | 8 |
| 10007 | 14:30 | 174 | 9 |
| 10007 | 15:30 | 170 | 10 |
| 10007 | 13:00 | 169 | 11 |
| 10007 | 16:30 | 163 | 12 |
| 10007 | 12:30 | 153 | 13 |
| 10007 | 11:30 | 152 | 14 |
| 10007 | 16:00 | 148 | 15 |
| 10007 | 8:30 | 136 | 16 |
| 10007 | 17:00 | 128 | 17 |
| 10007 | 17:30 | 98 | 18 |
| 10007 | 8:00 | 92 | 19 |
| 10007 | 18:00 | 65 | 20 |
| 10007 | 18:30 | 50 | 21 |
| 10007 | 19:00 | 41 | 22 |
| 10007 | 19:30 | 35 | 23 |
| 10007 | 20:00 | 4 | 24 |
| 10007 | 13:30 | 2 | 25 |
Use a Group By, followed by adding an Index Column withing the grouped table:
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
2 Replies
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Use a Group By, followed by adding an Index Column withing the grouped table: