inserting missing rows in data

Hi EdJ ,

We can create a new table and two new columns to meet your requirement.

1. Create a new table that contains whole date and name.

Result table = 
CROSSJOIN(
    VALUES('Table'[Name]),
    VALUES('Table'[Date]))

2. Then we need to add the value column.

Value = 
CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Date]='Result table'[Date] && 'Table'[Name]= 'Result table'[Name]))

3. At last we can create the result column.

Column = 
VAR _date =
    IF (
        ISBLANK ( 'Result table'[Value] ),
        MAXX (
            FILTER (
                'Result table',
                'Result table'[Date] < EARLIER ( 'Result table'[Date] )
                    && 'Result table'[Value] <> BLANK ()
                    && 'Result table'[Name] = EARLIER ( 'Result table'[Name] )
            ),
            'Result table'[Date]
        ),
        'Result table'[Date]
    )
RETURN
    IF (
        ISBLANK ( 'Result table'[Value] ),
        CALCULATE (
            SUM ( 'Result table'[Value] ),
            FILTER (
                'Result table',
                'Result table'[Date] = _date
                    && 'Result table'[Name] = EARLIER ( 'Result table'[Name] )
            )
        ),
        CALCULATE ( SUM ( 'Result table'[Value] ) )
    )

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.