Forum Discussion

npombo's avatar
npombo
Icon for Helper I rankHelper I
4 years ago
Solved

Finding earliest date given a value in another column

Hello,   I am having trouble creating a measure that takes the earliest date based on a value in another column. To break it down in simpler terms, let's call the referenced column "Status" and the...
DAX
Filter
min
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi npombo ,

     

    Please use calculate() function to wrap the filter() formula.

    For example:

    measure = calculate(min([date]),filter(allselected('table'),[status]="Yes"))

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

npombo , try like

 

Measure2 = MINX(FILTER(allselected('Table Name'), 'Table Name'[Status] = "Yes"), 'Table Name'[Date])

 

orr

 

Measure2 = MINX(FILTER(('Table Name'), 'Table Name'[Status] = "Yes"), 'Table Name'[Date])