Invoice Payment Running Balance (Cummulative Total Balance)

Hi Ajungx ,

Please try this:

• Create a date table

Date = 
VAR t =
    CALENDAR ( MIN ( Invoicing[Date] ), MAX ( Payment[Date] ) )
RETURN
    ADDCOLUMNS (
        t,
        "Year", YEAR ( [Date] ),
        "Month", FORMAT ( [Date], "mmmm" ),
        "YearMonthNo",
            YEAR ( [Date] ) * 100
                + MONTH ( [Date] )
    )

• Create measures

Invoicing = 
VAR year_ =
    SELECTEDVALUE ( 'Date'[Date].[Year] )
VAR customer =
    SELECTEDVALUE ( Invoicing[Customer] )
VAR a =
    CALCULATE (
        SUM ( Invoicing[Amount] ),
        FILTER (
            ALL ( 'Invoicing' ),
            Invoicing[Date].[Month] = MAX ( 'Date'[Date].[Month] )
        )
    )
VAR b =
    CALCULATE (
        SUM ( Invoicing[Amount] ),
        FILTER (
            'Invoicing',
            Invoicing[Date].[Month] = MAX ( 'Date'[Date].[Month] )
                && ( Invoicing[Date].[Year] = year_
                || Invoicing[Customer] = customer )
        )
    )
RETURN
    IF (
        ISFILTERED ( 'Date'[Date].[Year] ) || ISFILTERED ( Invoicing[Customer] ),
        b,
        a
    )

Payment = 
VAR year_ =
    SELECTEDVALUE ( 'Date'[Date].[Year] )
VAR customer =
    SELECTEDVALUE ( Invoicing[Customer] )
VAR a =
CALCULATE (
    SUM ( Payment[Paid Amt] ),
    FILTER ( ALL ( Payment ), Payment[Date].[Month] = MAX ( 'Date'[Date].[Month] ) )
)

VAR b =
    CALCULATE (
    SUM ( Payment[Paid Amt] ),
    FILTER (  Payment , Payment[Date].[Month] = MAX ( 'Date'[Date].[Month] ) 
                && ( Payment[Date].[Year] = year_
                || Payment[Customer] = customer )
        )
    )
RETURN
    IF (
        ISFILTERED ( 'Date'[Date].[Year] ) || ISFILTERED ( Invoicing[Customer] ),
        b,
        a
    )

Balance = 
VAR LastYearMonthNo =
    MAX ('Date'[YearMonthNo])
VAR MonthToSum =
    FILTER (
        ALLSELECTED (
            'Date'[Month],
            'Date'[YearMonthNo]
        ),
        'Date'[YearMonthNo] <= LastYearMonthNo
    )
RETURN
SUMX(MonthToSum,[Invoicing]-[Payment])