Ranking by dates

[CarlsBerg999]

I have a table below where i have 2 projects and 5 tasks. I want to rank each task inside a project based on start date. Earliest would be number 1 etc. How do i rank the tasks in a project context based on the dates? 

Thanks for the help!

Project	Task	Start date	Rank
1	1	1.1.2021	1
1	2	1.3.2021	3
1	3	1.2.2021	2
2	1	15.3.2021	2
2	2	10.3.2021	1

[Jihwan_Kim · Accepted solution]

Hi, @CarlsBerg999 

Please try the below calculated measure.

Ranking =
VAR currentproject =
MAX ( 'Table'[Project] )
RETURN
RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Project] = currentproject ),
CALCULATE ( MAX ( 'Table'[Start date] ) ),
,
ASC
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@CarlsBerg999 , Create a new column like

rankx(filter(Table, [Project] = earlier([project])),[Start Date],,asc,dense)

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns