Dax For TopNCustomers

[Sonam1301]

Hey Everyone, 

I have two tables first 'Sales Data' from which I am focusing on columns 'Order Date', 'Shipping Mail Id' and 'Order Number' 

The second table is Calendar which is linked with the Sales Data table on the basis Calendar[ Date] and Sales Data[Order Date]. 

I want to know about the Top 5 customers' Order Count Grand total of every month. 

 for example I want a table like this. 

YEAR	MONTH	ORDER COUNT
2023	JULY	88
2023	JUNE	108
2023	APRIL	107

And the order count come from another table:

top 5 customer of month July

Shipping Mail Id	Order Count
x@gmail.com	xx
y@gmail.com	xx
h@gmail.com	xx
n@gmail.com	xx
k@gmail.com	xx
grand total	88

[v-binbinyu-msft]

Hi @Sonam1301 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.