I'm creating a Power Bi report.
I have a table which give list of applicable countries on monthly basis. I like to get top 10 countries of each month to show the monthly trend of top 10 items.
Below is the data sample - I need a rank number on countries - which is top 10 countries of feb and top 10 for mar. Can you please help me to make this?
Going forward, we will get monthly data similar to this. so, every month, we should get this. Not sure how to group date and country and get the rank for each month.