rank to start over when it reaches max

[lha]

 Hello Everyone,

I want to rank a set of dates from 1 to 13, once 13 as been reached, I would like the rank to start over again at one and keep on doing this until the end of my time period.

1/1/18 : rank 1

1/2/18:  rank 2

.

.

.

1/13/18: rank 13

1/14/18: rank 1

1/14/18: rank 2

Is this possible? 

[edhans · Accepted solution]

Try this:

Ranking - TRUNC((Ranking-1)/13,0) * 13

Ranking is your RANKX() measure.

[Greg_Deckler · Accepted solution]

If you already have a [Rank] measure then this should work:

Column 2 = 
VAR __mod = MOD([Rank],13)
RETURN IF(__mod=0,13,__mod) 

[edhans · Accepted solution]

Try this:

Ranking - TRUNC((Ranking-1)/13,0) * 13

Ranking is your RANKX() measure.

[lha · Accepted solution]

They both works! Thank you!

[Greg_Deckler]

I created a similar measure to this here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739

Probably could do something similar with RANKX but I'd need sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Greg_Deckler · Accepted solution]

If you already have a [Rank] measure then this should work:

Column 2 = 
VAR __mod = MOD([Rank],13)
RETURN IF(__mod=0,13,__mod)