Rolling 3 week Average

Hi cottrera ,

If you are creating a calculated column, then the cause of the eeors is that you added two commas after "ASC". You should add two commas before "ASC" to conform to the syntax. Try the following formula:

Week Rank = 
RANKX( 
    ALL('SHARED Calendar'), 
    'SHARED Calendar'[Week start], 
    , 
    ASC, 
    DENSE 
) 

 If you want to create measure, follow these steps to create two measures:

Measure 3 = MAX('SHARED Calendar'[Week start]) 

Week Rank = 
RANKX( 
    ALL('SHARED Calendar'), 
    [Measure 3], 
     , 
     ASC, 
     Dense 
) 

 If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
 
Best Regards,
Winniz
 
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.