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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi georgec96,
Can you try 
MinDate = CALCULATE ( MIN ( 'Table'[trndte]), ALLEXCEPT('Table'[Shift]))
MaxDate = CALCULATE ( MAX ( 'Table'[trndte]), ALLEXCEPT('Table'[Shift]))