Calculate Sales from Previous Year Month to Date

[Stuznet1]

Hi,

I'm struggling to get the Previous Year MTD calculation to work, and I'm trying to get the prior year month to date which is August 2021 only. How do I revise below formula for last year? 

This is my formula to the get the current MTD

CURRENT_MTD = CALCULATE(SUM(Data[Sales_Amount]), FILTER(Data, Data[FISCAL_DATE] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 01)), FILTER(Data, Data[FISCAL_DATE] < TODAY()))

Here is the result

Thanks bunch

[Stuznet1 · Accepted solution]

I figured it out myself

CALCULATE(SUM(Data[Sales_Amount]), 
                FILTER(Data, Data[FISCAL_DATE] <= DATE(YEAR(TODAY())-1, MONTH(TODAY()), DAY(TODAY()))),
                FILTER(Data, Data[FISCAL_DATE] >= DATE(YEAR(TODAY())-1, MONTH(TODAY()), 01)), 
                FILTER(Data, Data[FISCAL_DATE] < TODAY())
            )

Result