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

     

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