Calculate the SUM of Sales$ using a date range

[bhmiller89]

Data Points:

"OktoInvoiceDate," "OKtoInvoiceDate+90", "SaleDate", "Sale$"

I need to calculate the SUM(Sale$) that took place during the time frame between "OktoInvoiceDate" and "OktoInvoiceDate+90"

These need to be measures

I can't figure it out! 

[v-ljerr-msft]

Hi @bhmiller89,

If I understand you correctly, you should be able to follow steps below to get your expected result. 

1. Add an individual Calendar table if you don't have one yet.

Date = CALENDARAUTO()

2. Then you can use the formula below to create a measure to calculate the SUM(Sale$) for a selected date that took place during the time frame between "OktoInvoiceDate" and "OktoInvoiceDate+90". 

measure =
VAR currentDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        SUM ( Table1[Sale$] ),
        FILTER (
            Table1,
            Table1[OktoInvoiceDate] <= currentDate
                && Table1[OktoInvoiceDate+90] >= currentDate
        )
    )

Regards