Get Top5 by Dates

[PeterChu]

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

[Zubair_Muhammad · Accepted solution]

@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 · Accepted solution]

@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 · Accepted solution]

@PeterChu

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

[PeterChu]

It's work.Thank you very much.

[v-huizhn-msft]

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