Skip to content

Blog
Videos
Contact
About

Blog
Videos
Contact
About

Rank

Page Image - 2 ways to Rank with Ties

2 Ways to Rank With Ties Using Power Query

21st June 2020 by Rick de Groot Categories Power Query

Recently I worked on a challenge from Ken Puls, where I needed to figure out how to Rank With Ties. Ken had a set of …

Categories Power Query

Stay in the Loop

Get the latest Excel and BI advice, tips and in-depth tutorials delivered straight to your inbox.

Leave this field empty if you're human:

Subscribe to my Channel

Want Some Help

As well as being a blogger, I’m an independent consultant with a passion for Excel and Power BI. I have background in Finance and work with customers to find business solutions that increase insight and quicken decision making. I’d be happy to work on interim assignments.

For more details see:

Recent Posts

List.Accumulate in Power Query (Explained with Examples)
Create Date Table with Dynamic Language in Power Query
Creating Tables in Power Query M (40+ Examples)
Comparing Licenses in Power BI
Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

Tags

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

Categories

DAX
Excel
Power BI
Power Query

About BI Gorilla®

BI Gorilla is a free resource site for Excel and Power BI enthusiasts. BI Gorilla was founded in 2018 by Rick de Groot. The main goal of this site is to provide quality tips, tricks, hacks, and other resources that help you advance with Power BI and Excel.

RECENT POSTS

List.Accumulate in Power Query (Explained with Examples)
Create Date Table with Dynamic Language in Power Query
Creating Tables in Power Query M (40+ Examples)
Comparing Licenses in Power BI
Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI

TOPICS

Array Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Data Model Data Type Date.From Date.FromText Date Table DateTime.LocalNow Function Group By List List.Alternate List.Contains List.Count List.Dates List.Distinct List.First List.FirstN List.Generate List.Last List.Numbers List.PositionOf List.ReplaceMatchingItems List.Sum Parameter Pivot Power Pivot Record replace SUMIF SUMPRODUCT SUMX SWITCH Table Table.AddIndexColumn Table.FromColumns Text.Combine Text.Contains Text.End Text.From Text.Middle Text.PadStart Text.PositionOf

SOCIAL

YouTube
Twitter
LinkedIn
Facebook

Search for:

© 2022 Gorilla BI