Return First Order for Customer after Membership Date

[Anonymous]

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?

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Fowmy]

@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