Skip to content

Blog
Videos
Contact
About

Blog
Videos
Contact
About

Ties

Page Image - 2 ways to Rank with Ties

2 Ways to Rank With Ties Using Power Query

21st June 202025th May 2018 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 …

Read more2 Ways to Rank With Ties Using Power Query

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:
linkedin.com/in/rickmaurinus/

　

Recent Posts

Optimizing the performance of DISTINCTCOUNT in DAX
The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)
7 Ways to Open Multiple Instances of Excel
2 Awesome Tips on How to Use the SWITCH Function in Excel
3 Ways to SUM null values in Power Query

Tags

Add Column Array Break-line Calendar Carriage Return Column Type Concatenate Conditional Formatting conditional if-statement CROSSJOIN Cube Formula CUBEMEMBER CUBEVALUE Custom Column Custom Format Data Model Data Type Date Error Message Formatting Function Get and Transform Group By Index ISNUMBER List MATCH Modulo New Instance Paste Special Pivot Pivot Table Power Pivot Rank ROUND Split Column SUMIF SUMPRODUCT SUMX Table Table.ColumnNames Table.Group Table.Max Ties XLSB

Categories

DAX
Excel
Power BI
Power Query

About Excel Gorilla®

Excel Gorilla is a free resource site for Excel and Power BI enthusiasts. Excel 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

Optimizing the performance of DISTINCTCOUNT in DAX
The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)
7 Ways to Open Multiple Instances of Excel
2 Awesome Tips on How to Use the SWITCH Function in Excel
3 Ways to SUM null values in Power Query

TOPICS

Add Column Array Break-line Calendar Carriage Return Column Type Concatenate Conditional Formatting conditional if-statement CROSSJOIN Cube Formula CUBEMEMBER CUBEVALUE Custom Column Custom Format Data Model Data Type Date Error Message Formatting Function Get and Transform Group By Index ISNUMBER List MATCH Modulo New Instance Paste Special Pivot Pivot Table Power Pivot Rank ROUND Split Column SUMIF SUMPRODUCT SUMX Table Table.ColumnNames Table.Group Table.Max Ties XLSB

SOCIAL

YouTube
Twitter
LinkedIn
Facebook

Search for:

© Copyright 2018 - 2020 | Excel Gorilla | All Rights Reserved
Terms | Privacy | Contact

Scroll back to top