Forum Discussion
Rankx name, id per specific date parameters
I currently have a table with all the calls that the users makes (a different id per call), what I want to do is have an individual rank per id user, and the count have to restart per month.
This is what I have at the moment:
Order = RANKX(FILTER(Table,Table[User] = EARLIER(Table[User])),Table[Month],,ASC)
Any help is really appreciated
Anonymous , Try a new column like
Order = RANKX(FILTER(Table,Table[User] = EARLIER(Table[User]) && Table[Month] =earlier(Table[Month])),Table[key],,ASC)
2 Replies
- amitchandak
Super User
Anonymous , Try a new column like
Order = RANKX(FILTER(Table,Table[User] = EARLIER(Table[User]) && Table[Month] =earlier(Table[Month])),Table[key],,ASC)