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

     

     

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    PeterChu

     

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

     

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

     

    • PeterChu's avatar
      PeterChu
      Frequent Visitor
      8 years ago

      It's work.Thank you very much.

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        8 years ago

        Hi PeterChu,

        Glad to hear that you have resolved your issue. Please mark the right/helpful reply as answer. More people will learn new things here. 

        Thanks,
        Angelia