Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

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➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors