Forum Discussion

adelimont's avatar
adelimont
Regular Visitor
8 years ago
Solved

Rank top 10 data within each month

I'm new to Power BI and DAX and I haven't been able to find a solution to my problem.   I have a table organized with Job #, Month, Data. I would like to be able to add a column to rank the data wi...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI adelimont

     

    Try this column

     

    Rank Revenue by Month =
RANKX (
    FILTER ( 'YTD', 'YTD'[Month] = EARLIER ( 'YTD'[Month] ) ),
    'YTD'[Revenue],
    ,
    DESC,
    DENSE
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI adelimont

 

Try this column

 

Rank Revenue by Month =
RANKX (
    FILTER ( 'YTD', 'YTD'[Month] = EARLIER ( 'YTD'[Month] ) ),
    'YTD'[Revenue],
    ,
    DESC,
    DENSE
)