Earliest Date DAX Formula

[Janey_1980]

Hi,

Im trying to write a formula that brings back in a column in my powerpivot the earliest order booked date by customer.., Im currently using this formula but it doesnt seem to be working

=MAXX(FILTER('Query', EARLIEST([Customer_URN])=[Customer_URN]),[Booked_Date])

What am i doing wrong?

Thanks in advance Janey

 

[RoryA]

If you want the earliest date, you want MINX not MAXX.

 

[Janey_1980]

@RoryA thanks.... bloomin obvious too

 

[RoryA]

Glad to help, and a belated welcome to the forum!