Get first date using FIRSTDATE or MIN funciton

minodori — Sun, 21 Feb 2021 23:17:07 GMT

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.

Re: Get first date using FIRSTDATE or MIN funciton

rfigtree — Mon, 22 Feb 2021 01:15:09 GMT

try surrounding your meassure with calculate like this.

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