Forum Discussion
Cyriackpazhe
Helper III
Helper IIIRankX
Why is this happening. I want to rank the each quarter in the respective years. How come this is happening. Any explanation as to why this is happening when it should give the correct results. ...
BeaBF
Super User
Super UserCyriackpazhe Hi! Try with:
Rank2 =
RANKX(
ALLEXCEPT('Calendar', 'Calendar'[Date].[Year]),
[Total],
,
DESC,
Dense
)
BBF