First and last datetime stamp

[georgec96]

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 it doesn't work due to duplicated rows in the trndte column.

Measure = CALCULATE ( MIN ( 'Table'[trndte]), FIRSTDATE ( 'Table'[trndte] ) )

Any ideas would be much appreciated

Thanks

[tamerj1 · Accepted solution]

Hi @georgec96 

please try New Column

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

[georgec96]

@tamerj1  worked, thank you 

[Aditya_Meshram]

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