Find lowest time value in a column

[brief001]

I am looking for a DAX formula for a calculated column.

I want to see the earliest start, which must be the same [Date] and [Name].

[tamerj1 · Accepted solution]

Hi @brief001

please try

Earliest Start =
MINX (
    CALCULATETABLE (
        Table_Roster,
        ALLEXCEPT ( Table_Roster, Table_Roster[Date], Table_Roster[Name] )
    ),
    Table_Roster[Start]
)

[brief001]

Thanks for the quick response. Your formula is clear to me. Also immediately looked up something about 'ALLEXCEPT'. I can probably use this more often.

Thanks!