Rank by category and by date

[XTF_2020]

Hello everyone

How can I make a column calculated by category and by date?

Date	Category	Order
2020-08-01	A	1
2020-08-03	A	3
2020-08-03	A	3
2020-08-02	A	2
2020-08-04	A	4
2020-08-25	B	4
2020-08-03	B	1
2020-08-10	B	2
2020-08-10	B	2
2020-08-24	B	3
2020-08-21	C	4
2020-08-08	C	2
2020-08-02	C	1
2020-08-14	C	3

I would like to create a column to classify and sort each category by date.It's possible?

[amitchandak · Accepted solution]

@XTF_2020 ,

Check if you need a new column like this

Rank = RANKX(FILTER((RankTable), RankTable[Category]=EARLIER(RankTable[Category])),[Date],,asc,Dense)

[VijayP]

@XTF_2020

Is this the outcome do you require. Please let me know!

0