Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Helper V
5 years ago
Solved

Ranking by dates

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 b...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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/

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

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/