I want to filter historical data on different tables.

EVALUATE

{
VAR MaxDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        [Amount_AR],
        FILTER (
            ADDCOLUMNS (
                FILTER (
                    'CustomerInvoice',
                    'CustomerInvoice'[CustomerInvoicePaidDate] > TODAY ()
                        && 'CustomerInvoice'[CustomerInvoicePostingDate] <= TODAY ()
                        && 'CustomerInvoice'[CustomerInvoiceID] <> 0
                ),
                "OverdueDays",
                    IF (
                        'CustomerInvoice'[CustomerInvoiceDueDate] < TODAY (),
                        DATEDIFF ( 'CustomerInvoice'[CustomerInvoiceDueDate], TODAY (), DAY ),
                        DATEDIFF ( TODAY (), 'CustomerInvoice'[CustomerInvoiceDueDate], DAY ) * -1
                    )
            ),
            [OverdueDays] >= [DueDaysAgeGroupMinLowerBoundary]
                && [OverdueDays] <= [DueDaysAgeGroupMaxUpperBoundary]
                && [OverdueDays] >= [AgeGroupMinLowerBoundary]
                && [OverdueDays] <= [AgeGroupMaxUpperBoundary]
        ),
        FILTER ( ALL ( 'Date' ), 'Date'[Date] <= MaxDate )
    )
    }
 

EVALUATE

{
VAR MaxDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        [Amount_AR],
        FILTER (
            ADDCOLUMNS (
                FILTER (
                    'CustomerInvoice',
                    'CustomerInvoice'[CustomerInvoicePaidDate] > TODAY ()
                        && 'CustomerInvoice'[CustomerInvoicePostingDate] <= TODAY ()
                        && 'CustomerInvoice'[CustomerInvoiceID] <> 0
                ),
                "OverdueDays",
                    IF (
                        'CustomerInvoice'[CustomerInvoiceDueDate] < TODAY (),
                        DATEDIFF ( 'CustomerInvoice'[CustomerInvoiceDueDate], TODAY (), DAY ),
                        DATEDIFF ( TODAY (), 'CustomerInvoice'[CustomerInvoiceDueDate], DAY ) * -1
                    )
            ),
            [OverdueDays] >= [DueDaysAgeGroupMinLowerBoundary]
                && [OverdueDays] <= [DueDaysAgeGroupMaxUpperBoundary]
                && [OverdueDays] >= [AgeGroupMinLowerBoundary]
                && [OverdueDays] <= [AgeGroupMaxUpperBoundary]
        ),
        FILTER ( ALL ( 'Date' ), 'Date'[Date] <= MaxDate )
    )
    }