Formula to find the last known order date for a customer ID

user09112
user09112 Member
in Magic ETL

We have a table where we are trying to add up the customers total order value over a period of time and would like one column to note the last known order date for the customer. How would I write the statement to find that value?

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    If your table card already has individual rows for customers, you would need to create a BeastMode (Calculated Column) and just enter the following:

    MAX(`Order Date`)

    And just adjust if that's not the actual name of your order date column. 

     

    But that will return the most recent order date found for each customer. 

     

    If I've misunderstood what you're asking for or if you need further help, just let me know.

     

    Sincerely,

    Valiant

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    If your table card already has individual rows for customers, you would need to create a BeastMode (Calculated Column) and just enter the following:

    MAX(`Order Date`)

    And just adjust if that's not the actual name of your order date column. 

     

    But that will return the most recent order date found for each customer. 

     

    If I've misunderstood what you're asking for or if you need further help, just let me know.

     

    Sincerely,

    Valiant

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Categories