Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @talan12 ,
Does this one help you fixing your issue?
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! |
#proudtobeasuperuser |
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] )
)
)
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] )
)
)
Hi @talan12 ,
Does this one help you fixing your issue?
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! |
#proudtobeasuperuser |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |