First value in a time series

[JimB-GA]

I am in need of returning the first value in a time series.  Any help is most appreciated.

THanks

Jim

Example:

09:31 am                  93.76

09.41 am                  94.12

09:51 am                  91.89

10:01 am                  93.16

[EugenioJunior · Accepted solution]

Hi Jim,

Can that help?

Measure = 
CALCULATE(
            MIN('Table'[Value]),
            FILTER('Table','Table'[Time]=MIN('Table'[Time])
                    )
          )

[JimB-GA]

Yes!  Works perfectly.  Thank you for your quick reply.

Jim