Calculate first datetime on same day

[banthorpe]

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

[v-yulgu-msft · Accepted solution]

Hi @banthorpe ,

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