Go to Solution.
@HMJSomerset , Create a date from from Timestamp
Date = [Timestamp].date orDate = date(year([Timestamp]),month([Timestamp]),day([Timestamp]))
and then try this rank column
Daily Rank =RANKX(FILTER(ProvCapacity,ProvCapacity[ProviderID]=EARLIER(ProvCapacity[ProviderID]) && ProvCapacity[Date]=EARLIER(ProvCapacity[Date])),ProvCapacity[Timestamp])
Proud to be a Super User!
View solution in original post
Thank you. I have amended the DAX and it now works correctly.
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!