cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vengadeshpalani Regular Visitor
Regular Visitor

Rank function with group by in M Query

Hi all

i have data like below table 

 

TypeValuepercentage
AA1100
AA280
AA390
AA370
BB110
BB240
BB330
BB450

 

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? 

 

TypeValuepercentagePercentage Descending Order based on Type
AA11001
AA2803
AA3902
AA3704
BB1104
BB2402
BB3303
BB4501
1 ACCEPTED SOLUTION

Accepted Solutions
vengadeshpalani Regular Visitor
Regular Visitor

Re: Rank function with group by in M Query

1 REPLY 1
vengadeshpalani Regular Visitor
Regular Visitor

Re: Rank function with group by in M Query

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 420 members 4,342 guests
Please welcome our newest community members: