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 |
