Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I've been trying different ways to create a ranking, but without success
I would like to create an index measure by city and project, sorted by date.
Someone could help me ?
This is the result I would like to get
Solved! Go to Solution.
Hi @kasife ,
Based on the linked pbix, you used the latest release date by project to get the index but the dates on your screenshot do not match with your pbix.
That aside, if you want to use the latest date, create a calculated column for that first and then use that calculated column in RANKX.
Latest Release Date by Project =
CALCULATE ( MAX ( Tabela[Realese Date] ), ALLEXCEPT ( Tabela, Tabela[Project] ) )
Index =
RANKX (
FILTER ( Tabela, Tabela[City] = EARLIER ( Tabela[City] ) ),
Tabela[Latest Release Date by Project],
,
ASC,
DENSE
)
Proud to be a Super User!
Hi @kasife ,
Try this as a calculated column
rank =
RANKX (
FILTER ( 'DataTable', 'DataTable'[city] = EARLIER ( 'DataTable'[city] ) ),
'DataTable'[Date],
,
ASC,
DENSE
)
Proud to be a Super User!
@danextian
The ranking is still not giving the result I would like.
Below I put what it is returning me and the result I would like to get
Hi @kasife ,
Based on the linked pbix, you used the latest release date by project to get the index but the dates on your screenshot do not match with your pbix.
That aside, if you want to use the latest date, create a calculated column for that first and then use that calculated column in RANKX.
Latest Release Date by Project =
CALCULATE ( MAX ( Tabela[Realese Date] ), ALLEXCEPT ( Tabela, Tabela[Project] ) )
Index =
RANKX (
FILTER ( Tabela, Tabela[City] = EARLIER ( Tabela[City] ) ),
Tabela[Latest Release Date by Project],
,
ASC,
DENSE
)
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |