Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I need to create a Ranking Column based on 2 categories, (Description_Task and Approval_Date) for each NSRNUM as displayed below. I created a calculated column using DAX. But that doesn't give the desired result. Attached one screenshot for one of the NSRNUM. Kindly help.
Expectation:
TIA,
Tanisha
Solved! Go to Solution.
Hi, I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
It is for creating a new column.
RANK function (DAX) - DAX | Microsoft Learn
expected result calculated column =
RANK (
SKIP,
data,
ORDERBY ( data[approval_date], ASC ),
,
PARTITIONBY ( data[nsrnum], data[description_task] ),
MATCHBY ( data[nsrnum], data[description_task], data[approval_date] )
)
Hi, I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
It is for creating a new column.
RANK function (DAX) - DAX | Microsoft Learn
expected result calculated column =
RANK (
SKIP,
data,
ORDERBY ( data[approval_date], ASC ),
,
PARTITIONBY ( data[nsrnum], data[description_task] ),
MATCHBY ( data[nsrnum], data[description_task], data[approval_date] )
)
Hi @Jihwan_Kim , This one is perfectly working. Partition by is doing the job here. Thanks you so much 🙂
Hi @Anonymous ,
Based on the description, you seem to have solved the problem.
Please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Wisdom Wu
Hi @Anonymous - can you try the below calcuated column
Ranking_Group =
VAR CombinedValue =
'Table'[DESCRIPTION_TASK] & FORMAT('Table'[approval_date_fmt], "yyyymmdd")
RETURN
RANKX(
FILTER(
'Table',
'Table'[NSRNUM] = EARLIER('Table'[NSRNUM])
),
CombinedValue,
,
ASC,
DENSE
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi @rajendraongole1 ,
Dont see any ranking with this DAX expressions. Attaching the screenshot below also my sample pbix file. Kindly have a look. Thanks.
Best Regards,
Tanisha
Hi @Anonymous - Can you please try the solution provided by @Jihwan_Kim 👏
Proud to be a Super User! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
7 | |
6 | |
5 |
User | Count |
---|---|
20 | |
14 | |
10 | |
9 | |
6 |