How to Trigger Dynamic and Fixed Rankings in Power BI

How to Apply Ranking in Power Query / Ranking Sales Data in Power BI
In this video, we will learn two ranking methods in Power BI - static ranking using Power Query formulas and dynamic ranking using DAX functions.
We start with static ranking, where the rank is pre-calculated in Power Query before being pushed to Power BI. We'll then explore dynamic ranking in Power BI, where ranks are updated based on sales data and dynamically adjusted when filters are applied. #dax #powerbi
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/dynamic-and-fixe...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@GoodlyChandeep]

⬇Download the file used in the video - goodly.co.in/dynamic-and-fixed-rankings-power-bi 🔗Recommended Videos: What is Filter Context? - kzbin.info/www/bejne/hmq0ZHxvhqydfbssi=7x2Y0Jv8IsZDq4sN Context Transition in Power BI and Tricky Examples - kzbin.info/www/bejne/poWsY3SJnMqWfaMsi=mtOQuxZJskZgweco Row Context and Context Transition - kzbin.info/www/bejne/hJy8qKqYbK5meLssi=_e1R6bbBCE34Ws5a 💡Looking to Master Power BI? Check out my Comprehensive Course on DAX & Data Modeling! - goodly.co.in/learn-dax-powerbi/

[@Aditya00775]

Hi Chandeep, pls create a video on calculating TAT which excludes regional holidays in power query. Thanks a lottt, your videos are very awesome

[@sublimefan311311]

I spent 3 days and watched so many videos and went crazy trying to figure this out. THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@skv4611]

Love your unwavering dedication to share knowledge.

[@faruksedef]

Why this guy's all videos are awesome, I am really in jealous, :)))

[@GoodlyChandeep]

😂 🙌

[@IvanCortinas_ES]

The best in this field, without a doubt. Excellent explanations again and again. Thanks Chandeep!

[@Ratnakumarwrites]

Explaining other ranking types also could have made in the video.

[@gennarocimmino]

Hi Chandeep, Thank you for sharing this tutorial. Very clear as always. see you next time. :)

[@Hello-bn2yc]

Brilliant... Thank you Chandeep

[@Nalaka-Wanniarachchi]

Nice video as usual Chandeep !!! .Instead of rankx i prefer to use rank function now.

[@arbazahmad7177]

Incredible 🎉.. thanks for sharing

[@chrism9037]

Brilliant as always, thanks Chandeep!

[@GoodlyChandeep]

Thanks again!

[@gaben6764]

sorry if this is a dumb question, but i'm trying to understand what specifically makes the 2nd solution "dynamic". Is it using a row context function? and how does it being combined with all(or all selected/except for that matter) help with the query being dynamic. (i know my comment comes across as a bit all over the place, but would appreciate any pointers, thanks!)

[@carloserodriguez2465]

It is dynamic because the measure is being recalculated if you filtered any other column meanwhile the ranking coming from power query is static and is not going to be recalculated is you filter the underlying data

[@shamf6624]

Amazing. So intelligent

[@md_elias]

Incredible, much thanks to you brother. It would be great if you please share a video about deleting all column except the selected column from the column legend name in Power query. - Elias

[@MiteshYadav]

Excellent explanation.. I have one question i am working on statistic control chart dashboard ,where there are various rules violation. Suppose for example Rule 1 says if consecutive points are below zero sigma then it is violating rule 1. I have successfully built all the rules and they are working fine. But the problem is whenever there is violation of rule 1, then at 8th point it is showing violation which is fine but i want to highlight 1 to 7 points along with 8th point so that it brings good user experience. To achieve that i have used dax measure but problem is measures are iterating row and i want result at column level. I also tried creating calculated column but it won't work. Is there any solution for it ?..

[@evilangel4136]

In dax how include rank by year?

[@Aditya00775]

Hi Chandeep, pls create a video on how to calculate TAT which excludes regional holidays in power query and DAX

[@GoodlyChandeep]

Please send me some sample data and expected output. [e-mail]

[@Aditya00775]

@@GoodlyChandeep I have sent you sample file. Thank you!!

[@miksosnowy1038]

is it not better to use AllSelected instead of All? then you will have ranks updated from 1.

[@GoodlyChandeep]

Yes if you are going to apply filter on products

[@123mrbala]

👏

[@rayees_thurkki]

Can you clear me one of my doubts? I am seeking your help

[@rangasanthosh4956]

yeap

[@rayees_thurkki]

@@rangasanthosh4956 Guys, I am a beginner in Power BI and still learning. I have a doubt about a DAX code. Could you please help me sort it out? I have a slicer connected to a table and the values are 'Group1', 'Group2', and 'Group3.' If the slicer's selection value is 'Group1', the day column should be filtered by Days >=0 and Days =0 and Days

[@rayees_thurkki]

@@rangasanthosh4956 How we can filter a table with multiple columns values ( for example I have a table contains products name, expiry date and status showing expire within 30days, 60 days, 90 days and 120 days. I have shown in my slicer values as 30 days, 60days, 90 days and 120 days. If I select the value as 30 then table will show all the products expire within 0 to 30 days and if if i select 60 days then I need see all the products from 0 to 60 days. How i can do this