Forum Discussion

Sonam1301's avatar
Sonam1301
New Member
3 years ago

Dax For TopNCustomers

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. 

 

YEARMONTHORDER COUNT
2023JULY88
2023JUNE108
2023APRIL107

 

 

And the order count come from another table:

top 5 customer of month July

Shipping Mail IdOrder Count
[email protected]xx
[email protected]xx
[email protected]xx
[email protected]xx
[email protected]xx
grand total88
DAX Equation
Dax_Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.