Running total for missing dates

Hello bweiland,
i have used a separate date table to include missing dates in sales table and set up relationship between 
date table and sales table:

Then i used the following measure to get desired running total, i also observed running total and sales are grouped by GL account

Running Total =

CALCULATE(

    SUM('Sales_Table'[sales]),

    FILTER(

        ALLSELECTED('Date_table'[Date]),

        ISONORAFTER('Date_table'[Date], MAX('Date_table'[Date]), DESC)

    )

)

if this helps, please mark as solution

Hi bweiland 

You can't assign a value to a row that doesn't exist in your data. If January 2 isn't present in your table, no value can be shown for it. To handle this, use a dedicated calendar table with a continuous range of dates, and make sure it's marked as a date table in your model. Set and use date tables in Power BI Desktop

Running Total = 
CALCULATE (
    SUM ( FactData[Value] ),
    FILTER (
        ALL ( CalendarTable[Date] ),
        CalendarTable[Date] <= MAX ( CalendarTable[Date] )
    )
)

Please see the attached pbix.