duplicating row until next date or today's date

RMV 

Try this:

NewTable_V2 =
GENERATE (
    Table1;
    GENERATESERIES (
        CALCULATE ( MIN ( Table1[Date] ) );
        VAR FirstDay_ =
            CALCULATE ( MIN ( Table1[Date] ) )
        VAR LastDay_ =
            CALCULATE (
                MIN ( Table1[Date] );
                FILTER ( ALL ( Table1[Date] ); Table1[Date] > FirstDay_ );
                ALLEXCEPT ( Table1; Table1[Asset No.]; Table1[Type]; Table1[Capacity] )
            )
        RETURN
            IF ( ISBLANK ( LastDay_ ); TODAY (); LastDay_ - 1 )
    )
)

It fills up the last one up to today as you described initially. The new date column will be shown as "Value" and the old Date column is shown as well. You can use SELECTCOLUMNS to remove the old one and change the name of the new one.

Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

Cheers