Forum Discussion

fmatioli06's avatar
fmatioli06
Frequent Visitor
8 years ago
Solved

Find earliest Date from column with possible repeated row value

Hi All, I would really appreciate any DAX help I can get with this. I am trying to create a calculated column that finds the first date when the "Goal Met" column shows "completed" or in other word...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    fmatioli06

     

    It works when I add dummy ID to your sample data :smileysurprised:

    Please see the pic below

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Try the following Dax and see if it get the results you want

 

Column = IF(Table[Goal Met]="Completed",CALCULATE(FIRSTNONBLANK(Table[Date],1),ALLEXCEPT(Table,Table[Goal Met])))