DAX HELP - First Sales Date After Customer Re Registers

[NotSoSlick]

Hi Dax Fam,

We have a client group that needs to register before they can place an order. I want to identify their first order date After they have re-registered. I'm completely stuck,

I'm trying the below but I'm not understanding something

=CALCULATE(MIN(Order Date]),FILTER(ALL(Order Date),[Order Date] >Most Recent Registration Date)

(Table Names and coloumns summarized)

See below tables and desired output

Customer Table
Customer Name	Most Recent Registration Date
Sam	2/25/23
Jamie	1/01/23
Steve	2/10/23
Mike	12/20/22

Sales Table
Customer Name	Order Date
Sam	2/13/23
Sam	2/27/23
Sam	3/30/23
Jamie	12/02/22
Jamie	12/27/22
Jamie	1/06/23
Jamie	1/31/23
Steve	1/31/23
Steve	2/11/23
Steve	3/03/23

Output
Customer Name	First Order Date after Re-Registration Date
Sam	2/27/23
Jamie	1/06/23
Steve	2/11/23

Thanks for your help!

The NotSoSlick Noob!

[NotSoSlick]

Thank you Jihwan! Now i Found other issues with Dates coming in as text! Thank you so much for your help! You are super!

Cheers!

NotSoSlick

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new measure.

expected result measure: = 
IF (
    HASONEVALUE ( Customer[Customer Name] ),
    CALCULATE (
        MIN ( Sales[Order Date] ),
        FILTER (
            Sales,
            Sales[Order Date] > RELATED ( Customer[Most Recent Registration Date] )
        )
    )
)