How can I make a column calculated by category and by date?
I would like to create a column to classify and sort each category by date.It's possible?
Go to Solution.
Check if you need a new column like this
Rank = RANKX(FILTER((RankTable), RankTable[Category]=EARLIER(RankTable[Category])),[Date],,asc,Dense)
View solution in original post
Is this the outcome do you require. Please let me know!
Proud to be a Super User!
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.