cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterChu Frequent Visitor
Frequent Visitor

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

 

000.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

Re: Get Top5 by Dates

@PeterChu

 

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

 

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

 

 

Try my new Power BI game Cross the River

View solution in original post

Super User III
Super User III

Re: Get Top5 by Dates

@PeterChu

 

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

 

6006.png

Try my new Power BI game Cross the River

View solution in original post

4 REPLIES 4
Super User III
Super User III

Re: Get Top5 by Dates

@PeterChu

 

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

 

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

 

 

Try my new Power BI game Cross the River

View solution in original post

Super User III
Super User III

Re: Get Top5 by Dates

@PeterChu

 

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

 

6006.png

Try my new Power BI game Cross the River

View solution in original post

PeterChu Frequent Visitor
Frequent Visitor

Re: Get Top5 by Dates

It's work.Thank you very much.

Microsoft v-huizhn-msft
Microsoft

Re: Get Top5 by Dates

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

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors