Ranking by Multiple Columns (Guest Post by BI Elite)

preview_player
Показать описание

Today's video is a guest post from Parker over at BI Elite. Parker has generously agreed to do a guest video for my channel, where he'll explain how to use DAX to create a ranking based on multiple columns. So give it a watch and see how quickly and easily it can be done.

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:12 - Start of Demo
0:38 - Showing the Model
1:40 - Creating 1st DAX Measure
3:26 - Creating 2nd DAX Measure

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop
  1. Havens Consulting
  2. Power BI
  3. PowerBI
  4. PBI
  5. DAX
  6. Data Modeling
Рекомендации по теме
Ranking by Multiple 0:05:33

Ranking by Multiple Columns (Guest Post by BI Elite)

Compute a ranking 0:22:59

Compute a ranking based on multiple columns

[Google Sheets] How 0:03:19

[Google Sheets] How to rank by multiple columns

Rank based on 0:04:27

Rank based on multiple columns - Power BI - DAX

Ranking within a 0:04:25

Ranking within a Group with Power Query

POWER BI | 0:03:59

POWER BI | Ranking Based on Two Columns

Power BI Rank 0:05:49

Power BI Rank Within a Group Using the RANKX Function #Q&A

RANK COLUMN IN 0:03:04

RANK COLUMN IN POWER QUERY | HOW TO CREATE RANK COLUMN IN POWER BI | NEW POWER BI FEATURE

How to create 0:07:47

How to create Multi Rank based on Multiple Criteria in MS Office Excel Spreadsheet 2016

Multiple ranking | 0:08:24

Multiple ranking | Excel formula for data analysis

Power BI RANKX 0:08:22

Power BI RANKX - How To Rank Using Multiple And Even Weighted Columns

Ranking Values with 0:11:04

Ranking Values with Power Query

How to Dynamically 0:09:24

How to Dynamically Rank with Ties in Power Query

Rank your values 0:12:55

Rank your values using RANKX DAX Function in Power BI // Beginners Guide to Power BI in 2021

Lesson 9 - 0:12:03

Lesson 9 - Using RANKX formula in Power BI & RANK function in SQL Querying

Power BI DAX: 0:08:31

Power BI DAX: Data Values Ranking within Subgroup with RANKX

Intermediate Power BI 0:12:14

Intermediate Power BI - How to rank using RankX

Adding Pre Calculated 0:10:03

Adding Pre Calculated Rank in Power BI Using Power Query

How to Create 0:08:07

How to Create Multiple Rank Based on Multiple Criteria in Excel

Power BI- Rank 0:07:39

Power BI- Rank across more than one table| RANKX, Summarize| Rank across dimension tables

AIRBNB Interview Question 0:08:24

AIRBNB Interview Question Explained - Python Data Science | 'Ranking Most Active Guests' |...

Excel Magic Trick 0:12:10

Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufactu...

Rank Values In 0:02:25

Rank Values In Visual In Power BI | RANKX Function In DAX

Excel: RANK function 0:05:31

Excel: RANK function and rank by groups using SUMPRODUCT by Chris Menard

Комментарии
Автор

This has been a lifesaver. Had searched dozens of blogs and videos, and this finally gave me the answer.

yout
Автор

I have been looking for a tutorial on this EXACT situation for at least two weeks! You are the man!


Thank you much

DF-yjqs
Автор

Nice to see collaboration in the community! Great, easy to understand video!

cleanermail
Автор

Question: What if we add another column of 'months' and want to find the highest rank for each social netwrk and the month in which they had highest rank?

fuubutsushio
Автор

Hi, is there a possibility to do it for column in a table inside model, not in visualisation?

KK-kcmf
Автор

This would be exactly what I need....except that I get a circular dependency error in my model. Any ideas why that might happen?

RobIvy
Автор

Cool! Question -- does this only work when using "MAX" or can you use other variations?

kevinlabore
Автор

Can we have same values for 2 records? So lets say for Facebook, we have 2 records with same value like 100 . Then will be populated by the RANKX function. I need increment number for each record irrespective of duplicate record. How can achieve that?

suniltak
Автор

Hi, I tried the same way on my computer but technically i am faceing some error

rajeshkhanna
Автор

I have customer name, customer state and sale amount. But I want to rank based on customer name. Please help

jithiljohn