question

SajnaMohammed-7831 avatar image
0 Votes"
SajnaMohammed-7831 asked Ehren published

Use Ranx for top 10 column (country) on monthly basis.

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.
82406-image.png


power-query-not-supported
image.png (67.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered Ehren published

This question is related to Power BI, not Power Query. Please post it over in the Power BI Community forum.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.