First value in a time series

Question

I am in need of returning the first value in a time series.&nbsp; Any help is most appreciated.&nbsp;THanks&nbsp;Jim&nbsp;Example:&nbsp;09:31 am&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 93.7609.41 am&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 94.1209:51 am&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 91.8910:01 am&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 93.16

eugeniojunior · Accepted Answer

Hi Jim,Can that help?&nbsp;Measure = 
CALCULATE(
            MIN('Table'[Value]),
            FILTER('Table','Table'[Time]=MIN('Table'[Time])
                    )
          )&nbsp;

Forum Discussion

First value in a time series

2 Replies

Related content

how to append calculated values to current time series

Generate Series input value

Show 2 Series Values On Line Chart

Month Series

Generating rows based on values in several columns - Ungrouping values in a time series dataset