Forum Discussion

minodori's avatar
minodori
Regular Visitor
5 years ago
Solved

Get first date using FIRSTDATE or MIN funciton

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's avatar
    rfigtree
    5 years ago

    try surrounding your meassure with calculate like this.

     

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

1 Reply

  • rfigtree's avatar
    rfigtree
    Icon for Resolver III rankResolver III
    5 years ago

    try surrounding your meassure with calculate like this.

     

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