Rank function with group by in M Query

[Anonymous]

Hi all

i have data like below table 

Type	Value	percentage
A	A1	100
A	A2	80
A	A3	90
A	A3	70
B	B1	10
B	B2	40
B	B3	30
B	B4	50

i want to add a rank column by using percentage, based on the type 

i need this logic in M query, How can I achieve? 

Type	Value	percentage	Percentage Descending Order based on Type
A	A1	100	1
A	A2	80	3
A	A3	90	2
A	A3	70	4
B	B1	10	4
B	B2	40	2
B	B3	30	3
B	B4	50	1

[Anonymous · Accepted solution]

https://blog.crossjoin.co.uk/2015/05/11/nested-calculations-in-power-query/