Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return Earliest Date

Dax formula but returning same date for all ID, I need help applying filter on the ID    Attempt = IF('Table'[Attendance]="Pending",CONVERT(MIN([StartDate]),STRING)," ")   Attendance StartDa...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I managed to fix this : 

    Attempt = IF([Attendance]="Pending",CALCULATE(FORMAT(MIN(Table[StartDate]),"DD/MM/YYYY"), ALLEXCEPT('Table',Table[contactid]))," ")
     
    Thanks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I managed to fix this : 

Attempt = IF([Attendance]="Pending",CALCULATE(FORMAT(MIN(Table[StartDate]),"DD/MM/YYYY"), ALLEXCEPT('Table',Table[contactid]))," ")
 
Thanks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Is there anything else need help about this thread? If no, could you please mark it as Answered? Thank you.

Best Regards

Rena