Forum Discussion

georgec96's avatar
georgec96
Icon for Helper II rankHelper II
4 years ago
Solved

First and last datetime stamp

Hi everyone, I have the following dataset    I am trying to get the first and last datetime stamp for each shift (there are multiple shifts A,B,C,D) per day.   I have tried this formula but...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi georgec96 

    please try New Column

    Last DateTime =
CALCULATE (
    MAX ( 'Table'[trndte] ),
    ALLEXCEPT ( 'Table', 'Table'[Shift], 'Table'[Date] )
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi georgec96 

please try New Column

Last DateTime =
CALCULATE (
    MAX ( 'Table'[trndte] ),
    ALLEXCEPT ( 'Table', 'Table'[Shift], 'Table'[Date] )
)