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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Not sure why you want make that string and what date you want

Try new column like

Attempt = IF('Table'[Attendance]="Pending",[StartDate]+""," ")

Or

min date for ID = minx(filter(Table,[contactid]=earlier([contactid])),[StartDate]) + ""

  • 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