Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to 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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@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
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |