Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rank Dates within a Category or Group - DAX or Power Query

Hi,   I'm looking to rank my data to find the most recent information for each category.   Here's a brief example of the data I'm working with:     I have a Category column, a Date colum...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

     Anonymous

     

    As a calculated column with DAX

     

    RANK=RANKX(fILTER(Table1,[Category]=EARLIER([Category])),[Date],,DESC,dENSE)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

 Anonymous

 

As a calculated column with DAX

 

RANK=RANKX(fILTER(Table1,[Category]=EARLIER([Category])),[Date],,DESC,dENSE)
Elvos's avatar
Elvos
Regular Visitor
5 years ago

Hi, what if you get a D category in one of the later dates and want to rank it accordingly to that date rank in the other categories?

 

BR