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

    try surrounding your meassure with calculate like this.

     

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

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))