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

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

Hi Jay, this worked! Thank you for assisting me.