Hi. If I have the below and want to rank it as below (it's not dense but not sure how you call this sort of ranking index sorry) so that it brings only the last dates calls of the month per country, which would be the best way in your own experience, ranking or grouping? I know there are several ways of achieving this like ranking it as below which I am not sure how to achieve it in Power Query. I am doing it in Power Query but it would be interesting to know how can I achieve the indexing it like in the Rank field below but using DAX instead. I have tried using variables but I don't get it right. Much appreciated
Origine | Calls | Date | Rank |
Spain | 3 | 05-May | 1 |
Portugal | 8 | 01-May | 2 |
USA | 3 | 22-Mar | 1 |
Portugal | 2 | 02-Mar | 2 |
USA | 8 | 01-Mar | 3 |
England | 2 | 24-Feb | 1 |
Spain | 5 | 08-Feb | 2 |
England | 8 | 05-Feb | 3 |
USA | 6 | 05-Jan | 1 |
England | 3 | 01-Jan | 2 |