cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
talan12
New Member

power bi - ranking date

hello 🙂

 

I tried to make a ranking on a date so that every beginning of a month it resets but I can't get it. the furthest I got is that every month simply gets an cumulative ranking based on RANKX on power bi which includes a month and a year. Has anyone needed such a ranking and succeeded?

 

 

2 ACCEPTED SOLUTIONS
tackytechtom
Super User
Super User

Hi @talan12 ,

 

Does this one help you fixing your issue?

 

https://www.tackytech.blog/how-to-crack-the-mystery-of-the-mighty-dax/#create-ranks-and-indexes-dyna...

 

Otherwise, could you provide some sample on how you exactly would like to rank the data. Also, do you want to do this in DAX as a measure or a calculated column or rather a new column in Power Query? 

 

Let me know 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

tamerj1
Super User
Super User

Hi @talan12 

for measure please try

=
COUNTROWS (
    FILTER (
        CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Year] ) ),
        'Table'[Date] <= MAX ( 'Table'[Month] )
    )
)

for calculated column please try

=
COUNTROWS (
    FILTER (
        CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Year] ) ),
        'Table'[Date] <= EARLIER ( 'Table'[Month] )
    )
)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @talan12 

for measure please try

=
COUNTROWS (
    FILTER (
        CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Year] ) ),
        'Table'[Date] <= MAX ( 'Table'[Month] )
    )
)

for calculated column please try

=
COUNTROWS (
    FILTER (
        CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Year] ) ),
        'Table'[Date] <= EARLIER ( 'Table'[Month] )
    )
)
tackytechtom
Super User
Super User

Hi @talan12 ,

 

Does this one help you fixing your issue?

 

https://www.tackytech.blog/how-to-crack-the-mystery-of-the-mighty-dax/#create-ranks-and-indexes-dyna...

 

Otherwise, could you provide some sample on how you exactly would like to rank the data. Also, do you want to do this in DAX as a measure or a calculated column or rather a new column in Power Query? 

 

Let me know 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors