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]
)

2 Replies

  • 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!