Forum Discussion

brief001's avatar
brief001
Icon for Helper II rankHelper II
3 years ago
Solved

Find lowest time value in a column

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].        
calculated column
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi brief001

    please try

    Earliest Start =
MINX (
    CALCULATETABLE (
        Table_Roster,
        ALLEXCEPT ( Table_Roster, Table_Roster[Date], Table_Roster[Name] )
    ),
    Table_Roster[Start]
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi brief001

please try

Earliest Start =
MINX (
    CALCULATETABLE (
        Table_Roster,
        ALLEXCEPT ( Table_Roster, Table_Roster[Date], Table_Roster[Name] )
    ),
    Table_Roster[Start]
)
brief001's avatar
brief001
Icon for Helper II rankHelper II
3 years ago

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!