topic Re: Rank 1,2 , 1,2,3 in DAX Commands and Tips

Rank 1,2 , 1,2,3

Jyaul1122 — Thu, 11 Sep 2025 12:17:12 GMT

Hi, I have a table and need to find like Rank(Required Column).

I need to get DAX column like Rank for each Project and Order via Date . For example Project P1 have order A and B and their Date so that for Order A result will be like 1 and 2 and also for B will be 1 and 2 as show below:

for P2:

For P3 there are two order but repeat three times so that output will be

How can achieve using DAX Column

Row data:

Project	Order	Date
P1	A	9/14/2025
P1	A	9/15/2025
P1	B	9/16/2025
P1	B	9/17/2025
P2	C	5/7/2025
P2	D	5/7/2025
P2	C	5/9/2025
P3	G	7/8/2024
P3	H	7/9/2024
P3	H	7/10/2024
P3	G	7/5/2024
P3	H	7/6/2024
P3	G	7/7/2024

Re: Rank 1,2 , 1,2,3

johnt75 — Thu, 11 Sep 2025 12:56:02 GMT

You can create a calculated column like

Rank = RANK( ALL( 'Table'[Project], 'Table'[Order], 'Table'[Date] ), ORDERBY( 'Table'[Date], ASC ), PARTITIONBY( 'Table'[Project], 'Table'[Order] ) )

Re: Rank 1,2 , 1,2,3

Gabry — Thu, 11 Sep 2025 13:04:41 GMT

Heyyy,

this is your column

rank column = RANK(DENSE,,ORDERBY('Table'[Date]),,PARTITIONBY('Table'[Project], 'Table'[Order] ))

Re: Rank 1,2 , 1,2,3

Anonymous — Fri, 12 Sep 2025 09:47:03 GMT

Hi Jyaul1122 ,
Thanks for reaching out to the Microsoft fabric community forum.

I have used the DAX code provided by johnt75 to create the required rank order for your data

Here is the generated output:

Attaching the .pbix file for reference

I hope this information helps. Please do let us know if you have any further queries.
Thank you

Re: Rank 1,2 , 1,2,3

Anonymous — Mon, 15 Sep 2025 09:42:26 GMT

Hi Jyaul1122 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

Re: Rank 1,2 , 1,2,3

Anonymous — Fri, 19 Sep 2025 05:16:25 GMT

Hi Jyaul1122

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

Re: Rank 1,2 , 1,2,3

Anonymous — Mon, 22 Sep 2025 04:11:52 GMT

Hi Jyaul1122

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards