Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

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?

Super User
Super User


Share some data and show the expected result.

Ashish Mathur
Super User
Super User


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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors