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)
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.