Forum Discussion

PeterChu's avatar
PeterChu
Frequent Visitor
8 years ago
Solved

Get Top5 by Dates

Hi,

I want to do get top5 RegisteredNumbers measure by dates and Nickname in power bi desktop,but I don't know how to do.Hope you guys can help me out, thanks in advance

 

I want to do as I shown bellow

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    PeterChu

     

    First Add a Rank Column (Calculated Column) in your Table

     

    RANK =
RANKX (
    FILTER ( TableName, TableName[Date] = EARLIER ( TableName[Date] ) ),
    TableName[RegisteredNumbers],
    ,
    DESC,
    DENSE
)

     

     

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    PeterChu

     

    First Add a Rank Column (Calculated Column) in your Table

     

    RANK =
RANKX (
    FILTER ( TableName, TableName[Date] = EARLIER ( TableName[Date] ) ),
    TableName[RegisteredNumbers],
    ,
    DESC,
    DENSE
)

     

     

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      PeterChu

       

      Now you can use a VISUAL level filter in Power BI or PIvot Table filter in Excel for top 5