Forum Discussion
Adding Dense rank
Hi guys, Can anyone suggest a DAX to add a dense rank over a column and partition by two column. Below is my sample dax for single partition: RANKX(FILTER(table,table[Date]=EARLIER(table[Date]...
https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/
Read this article , hope it help you
tamerj1
Community Champion
Community ChampionHi Anonymous
You may try
Ranking =
RANKX (
CALCULATETABLE ( table, ALLEXCEPT ( table, table[Date], table[Column] ) ),
table[Date_Time],
,
ASC,
DENSE
)Thank you very much.