Time Series

MintuBaruah , Try two measures like

Bal-Start of day= firstnonblankvalue(Table[time], min(Table[Balance]))

Bal-End of day = lastnonblankvalue(Table[time], min(Table[Balance]))

Hi， MintuBaruah ；

You also could create a measure as follows:

Start =
VAR _min =CALCULATE ( MIN ( [Time] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) )
RETURN
    CALCULATE (MIN ( [Balance] ), FILTER ( ALLEXCEPT ( 'Table', 'Table'[Date] ), [Time] = _min ))

End =
VAR _max =CALCULATE ( MAX ( [Time] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) )
RETURN
    CALCULATE (
        MIN ( [Balance] ),
        FILTER ( ALLEXCEPT ( 'Table', 'Table'[Date] ), [Time] = _max ))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.