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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This is exactly what I was looking for. Thanks Zubair_Muhammad

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Zubair,
    Can you please advise how we can make this rank dynamic, meaning it will auto populate based on date range selected. Right now, even if you filter a later date out, it will still show the same rank.