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

[AW1976NOVA]

Hi,

I am trying to create a measure using DAX that will return the earliest date of the field [Paid Date].  The field [Paid Date] is in the table 'Claims_RawData'.

I have tried using several different combinations without any luck:

1) min('Claims_RawData'[Paid Date])

2) calculate(min('Claims_RawData'[Paid Date]))

I am not sure why this is not working.  I would like to create a simple card visual, drop my created measure in the card visual and have it return the earliest date available in the field [Paid Date].

Can you please assist?

[amitchandak · Accepted solution]

@AW1976NOVA , Try measure like

minX(allselected('Claims_RawData'),'Claims_RawData'[Paid Date])

or
minX(all('Claims_RawData'),'Claims_RawData'[Paid Date])