Get first date using FIRSTDATE or MIN funciton

[minodori]

Hi,

I've trid to get the first date from 'Date' column with below 2 DAX "MEASURE"s

1. firstDate = FIRSTDATE('Table 1'[Date])

2. minDate = min([Date])

But I didn't get the right results in the table visuals.

You can find all "firstData" and "minDate" are same with values in "Date" column

How to get the first data which shoud be "19-01-14" using DAX measures?

Many Thanks.

[rfigtree · Accepted solution]

try surrounding your meassure with calculate like this.

calculate(min(tale1[date]),all(table1))