How to Find Second Highest Value in Power BI

How to Find Second Highest Value in Power BI

Pettaka Technologies

54 года назад

11,981 Просмотров

In this video, explained "how to find second highest value in power bi ". We know how to find the maximum value using Max() Function and minimum value using Min() Function, but we can also find the Second, Third and Nth Maximum and Minimum Value using Large() and Small() Formula with "k" value or using Rankx() and Filter(). @PettakaTechnologies

Here "K" denotes the number which you required.Eg.2,3,4..

But we will not get the name of the highest person by using Max(),Min(),Large(),Small().

For getting names we will use Index() and Match() Function together and within that we can use Max(),Min(),Large(),Small() Function.

#tutorial
#powerbi
#pettakatechnologies
#powerbitutorial
#daxfunctions

To subscribe this Channel: https://www.youtube.com/c/PettakaTechnologies

Maximum Salesperson Name: =INDEX($D$11:$D$15,MATCH(MAX($G$11:$G$15),$G$11:$G$15,0))

Minimum Salesperson Name: =INDEX($D$11:$D$15,MATCH(MIN($G$11:$G$15),$G$11:$G$15,0))

Nth Maximum Salesperson Name: =INDEX($D$11:$D$15,MATCH(LARGE($G$11:$G$15,3),$G$11:$G$15,0))

Nth Minimum Salesperson Name: =INDEX($D$11:$D$15,MATCH(SMALL($G$11:$G$15,4),$G$11:$G$15,0))

RANKX for Second Highest:
= RANKX(ALLSELECTED(Employee), CALCULATE(SUM(Employee[Salary])), ,DESC,Dense)

To Find Second Highest Value:
= CALCULATE(MAX(Employee[Salary]), FILTER(ALLSELECTED(Employee),[Sal_Rank]=2))

- Learn Business Intelligence with Microsoft Power BI from Pettaka Technologies.
- Power BI Tutorial for Beginners 2024.
- Power BI by Pettaka Technologies.
- Data Visualization with Microsoft Power BI.
=============================================================
Playlists:

Microsoft Excel : https://www.youtube.com/playlist?list=PLJH3IJAeLguJ6x8KCp87SdQX5wSYmpr4O

Excel VBA Macro : https://www.youtube.com/playlist?list=PLJH3IJAeLguLVWWBGj7VN2vcl0iZ56drM

Power BI : https://www.youtube.com/playlist?list=PLJH3IJAeLguK_JyNcD6_bpPuR9bJqtBu0

Power BI DAX Tutorial : https://www.youtube.com/playlist?list=PLJH3IJAeLguI_5fCCSPFwUAyMq7e8WzTd
============================================================
Connect with us:
Subscribe | https://www.youtube.com/c/PettakaTechnologies

Facebook | https://www.facebook.com/PettakaTechnologies

LinkedIn | https://www.linkedin.com/company/pettaka-technologies

Twitter | https://twitter.com/PettakaTech

Previous Videos:

Use this link for Task_1_Separate the First name, Last name in PowerBI: https://youtu.be/hW1jArb7wVU

Use this link for Finding Middle name in Single Formula: https://youtu.be/u3EYm-epm1Y

Use this link for learning Basic PowerBI use this link: https://youtu.be/QUMYAE-6G_k

Facebook:

To get in Touch with Facebook use this link: https://www.facebook.com/PettakaTechnologies

Тэги:

#second_highest_value_in_power_bi #second_highest_value #2nd_highest_value #second_max_in_power_bi #power_bi_second_max #power_bi #dax_functions #power_bi_tutorial #calculate #second_highest #2nd_highest #second_max #find_second #find_second_highest #find_second_highest_value_in_power_bi #how_to_find_in_power_bi #find_max_value #select_second_highest_value #second_highest_value_in_column #power_bi_dax_functions #power_bi_functions_tutorial #pettaka_technologies #powerbi
Ссылки и html тэги не поддерживаются


Комментарии: