Community Center | Not monitored
Tag not monitored by Microsoft.
This question is related to Power BI, not Power Query. Please post it over in the Power BI Community forum.
Use Ranx for top 10 column (country) on monthly basis.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 82%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sajna Mohammed
1
Reputation point
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.
Community Center | Not monitored
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Ehren (MSFT) 1,781 Reputation points Microsoft Employee2021-04-09T21:46:51.387+00:00