Assigning sequence to orders based on customer Id

[rohanjha1988]

Hi All, 

I have a SalesMaster table in which customer ID and date wise sales details are given. I need to assign the sequence of orders based on sales date and customer id. I have attached the table. 

[amitchandak · Accepted solution]

@rohanjha1988 , See if Rank can help

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...