RANKX Query

[gmazza76]

Good afternoon

I am trying to do a rankx(all query in my data and failing miserably, hopefully I can be pointed in the right direction.

I need to create the "rankx(all" based on the "Contact No" and "Call End Date" to show 1 being the last call.
The formula I am using currently is showing all as rank 1 when the 20/07/21 & Phone No 1 should be as per the below. I have even tried to split the "Call End Date" into 2 separate columns but I am having no luck.

The formula I am using is as follows

=rankx(filter(all('Data1'),'Data1'[Contact]=earlier('Data1'[Contact])
&& 'Data1'[Call End Date]>earlier('Data1'[Call End Date])),
[Date],,0,Dense)

All help/advice appreciated.
Gavin

 

[gmazza76]

I have worked this out.
I needed to amend the [Date] to [Call End Date]