RANKX Query

[gmazza76]

Good afternoon,

I am using the formula below in 2 separate Power Pivot Tables, where 1 works and the other doesn't.
The only difference I can see is that one table has a "time" included in the "RDate" and the ranking works where as the one without doesnt.

Is there a way round this?

=RANKX(FILTER(ALL(SourceData),SourceData[REFNO]=EARLIER(SourceData[REFNO])),[RDate],,DESC,Dense)

thanks in advance
Gavin