Sum of last 3 months

[Anonymous]

I've searched on the forum to calculate the sum of last 3 months, but it seems that it does not work for me.

I would like to have the sum of Sep to Nov in December row.

Could you please help to see where is the problem from ?

Thank you.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

First ,if you don't have a unrelated calendar table, you need to create a new calendar table and use the date as a slicer.
Then create a measure to calculate sales:
sum_Sales_last_3_months =
CALCULATE (
    SUM( Sales[Sales] ),
    FILTER (
        ALL ( Sales[Date] ),
        Sales[Date] <= MAX ( DimDate[Date] )
            && Sales[Date] >= EDATE ( MAX(DimDate[Date]),-3 )
    )
)
 
You can also refer to the pbix.
If the problem persists,could you please share sample data or sample pbix?(Please mask any sensitive data before uploading)

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

[Anonymous]

Hi @V-lianl-msft ,

Thank you for the reply. It works when i unrelate my calendar table.

But is there other way not to unrelating and still able to calculat the last 3 months ?

Because I need to relate the calendar in the matrix.

Thanks,

Amy

[V-lianl-msft]

Hi @Anonymous ,

Measure has associated the unrelated calendar table with your existing date. You can use slicer to get the desired result. You can refer to the pbix file I published earlier.

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