Forum Discussion

Helper 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 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

please try New Column

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