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)," ")
 
AttendanceStartDatecontactidOutput
Pending28/02/2020 09:0000be6dc9-a11d-ea11-a811-27/02/2020
Pending27/02/2020 00:0000be6dc9-a11d-ea11-a811-27/02/2020
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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super 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