Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Return First Order for Customer after Membership Date

I'd like to return the first order date for a customer after the date they became a member of our program. I need to compare the membership date in our CUSTOMER table to the orders in our SALES table and return the date for the first order they placed. Each customer has a unique id that exists in both tables. How would I accomplish this?

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    Add the following column to your customer table:

     

    First Order Data = FIRSTNONBLANK(Orders[Order Date],SUM(Orders[Order Amount]))

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn