Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

need help identifying customers first, 2nd and so on orders

Hi,   i have a data set which contains customer orders and im trying to find a way to identify the customers purchases from their 1st order to their latest but i cant find a solution to the problem...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Try "Dense" in Rank function. I update your code.

    New calculated column:

    New Rank = 
RANKX(FILTER(Fact_table,Fact_table[business_partner_code]=EARLIER(Fact_table[business_partner_code])),Fact_table[demand_date_id],,ASC,Dense)

    Result is as below.

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

Try "Dense" in Rank function. I update your code.

New calculated column:

New Rank = 
RANKX(FILTER(Fact_table,Fact_table[business_partner_code]=EARLIER(Fact_table[business_partner_code])),Fact_table[demand_date_id],,ASC,Dense)

Result is as below.

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

arrowav36's avatar
arrowav36
Frequent Visitor
4 years ago

Hi,

Its showing this error while I am running this query can you please help me to resolve this?

Error : EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

 

I am trying to find the customers 1st, 2nd, 3rd and so on.. purchases, in front of each order I wanted to write that which number'th of order it is for that particular customer.

Please help me with the solution.