Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate first datetime on same day

OK - so I have a table of meeting start/end times. I'm trying to determine the earliest meeting start time of each day.

 

The data is in the attached picture. The 2nd and 3rd lines have meetings on the same day so FirstMeetingStartTime should be 19/12/2018 14:30:24 for both entries. How do I construct a DAX to do this?

 

-Dave

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    You can refer to below measure:

    first meeting time per day =
CALCULATE (
    MIN ( Table1[origStartDate] ),
    FILTER (
        ALL ( Table1 ),
        FORMAT ( Table1[origStartDate], "dd MMM YYYY" )
            = FORMAT ( SELECTEDVALUE ( Table1[origStartDate] ), "dd MMM YYYY" )
    )
)

     

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    You can refer to below measure:

    first meeting time per day =
CALCULATE (
    MIN ( Table1[origStartDate] ),
    FILTER (
        ALL ( Table1 ),
        FORMAT ( Table1[origStartDate], "dd MMM YYYY" )
            = FORMAT ( SELECTEDVALUE ( Table1[origStartDate] ), "dd MMM YYYY" )
    )
)

     

    Best regards,

    Yuliana Gu