First/earliest Date

Question

Hi&nbsp;i am trying to work out which is the earliest/First order date per customer as per the below. I have been trying to use the earlier function where the customer number = earlier customer number and order date = min order date but it doesn't seem to be working, i just get blanks.&nbsp; I am trying to create it as a calculated columnvar earliestdate = CALCULATE(MIN('customer'[Order Date]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER('customer', 'customer' [Customer Number]&nbsp;= EARLIER( 'customer' [Customer Number])))RETURNIF(Order Date&nbsp;= earliestdate , "First", BLANK())Customer NumberOrder NumberOrder DateProduct NumberOrdered1117/01/202512First1117/01/202513First1117/01/202514First1220/01/202512&nbsp;1220/01/202515&nbsp;1220/01/202516&nbsp;2318/01/202521First2318/01/202525First2431/01/202526&nbsp;2425/01/202521&nbsp;2425/01/202525&nbsp;3518/01/202521First3619/01/202523&nbsp;

pankajnamekar25 · Accepted Answer

Hello&nbsp;maurcoll&nbsp;&nbsp;Us this DAX to create calculated columnOrdered =VAR EarliestDate =&nbsp;&nbsp;&nbsp; CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MIN('customer'[Order Date]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALLEXCEPT('customer', 'customer'[Customer Number])&nbsp;&nbsp;&nbsp; )RETURN&nbsp;&nbsp;&nbsp; IF('customer'[Order Date] = EarliestDate, "First", BLANK())&nbsp;Thanks,&nbsp;Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Forum Discussion

First/earliest Date

2 Replies

Related content

Find first values per ID and earliest Date

Find first values per earliest Date

How to find the earliest date (or min date, or first date)

Remove earliest or first instance of field in Power Query

Help with Finding first Account name on earliest create date.

Customer Number	Order Number	Order Date	Product Number	Ordered
1	1	17/01/2025	12	First
1	1	17/01/2025	13	First
1	1	17/01/2025	14	First
1	2	20/01/2025	12
1	2	20/01/2025	15
1	2	20/01/2025	16
2	3	18/01/2025	21	First
2	3	18/01/2025	25	First
2	4	31/01/2025	26
2	4	25/01/2025	21
2	4	25/01/2025	25
3	5	18/01/2025	21	First
3	6	19/01/2025	23