Rank based on 3 column?

[ddpl]

I want to generate Requirement column based on below 3 columns...

Date----------	Name	Status	Requirement
11-Jan-22	ABC	P	ABC-P-1
11-Feb-22	ABC	P	ABC-P-1
11-Mar-22	ABC	A	ABC-A-2
11-Apr-22	ABC	A	ABC-A-2
11-May-22	ABC	A	ABC-A-2
12-May-22	ABC	A	ABC-A-2
13-May-22	ABC	P	ABC-P-3
14-May-22	ABC	A	ABC-A-4
15-May-22	ABC	A	ABC-A-4
11-Jan-22	DEF	P	DEF-P-1
11-Feb-22	DEF	A	DEF-A-2
11-Mar-22	DEF	A	DEF-A-2
11-Apr-22	DEF	P	DEF-P-3
11-May-22	DEF	P	DEF-P-3
12-May-22	DEF	A	DEF-A-4
13-May-22	DEF	A	DEF-A-4
14-May-22	DEF	P	DEF-P-5
15-May-22	DEF	P	DEF-P-5

[amitchandak]

@ddpl , Can you share the expected value?

For Rank Refer to these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[ddpl]

@amitchandak last column in above data is my requirement.