Rank in Power Query

[jcastr02]

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

[HotChilli · Accepted solution]

Use a Group By, followed by adding an Index Column withing the grouped table:

https://www.youtube.com/watch?v=7CqXdSEN2k4 

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[HotChilli · Accepted solution]

Use a Group By, followed by adding an Index Column withing the grouped table:

https://www.youtube.com/watch?v=7CqXdSEN2k4