Previous year previous month not calculating correctly

[NadiaLR1234]

Hi

I have this formula but it is not calculating the amounts correctly - please assist- it is for previous year previous month

CommissionPYPM =

VAR CurrentMonth = MONTH(TODAY())

VAR CurrentYear = YEAR(TODAY())

VAR StartDate = DATE(CurrentYear -1, CurrentMonth, -1)

VAR EndDate = EOMONTH(StartDate, 0)

RETURN

CALCULATE(

    SUM(vw_TTV[Commission]),

    FILTER(

        ALL(DimDate[DateFull]),

        DimDate[DateFull] >= StartDate && DimDate[DateFull] <= EndDate

    )

)

[JoeBarry · Accepted solution]

Hi @NadiaLR1234 

For previous year please try the following.

Create a base measure  

TotalCom = SUM(vw_TTV[Commission])

Create a YTD 

ComYTD = TOTALYTD([TotalCom], DIMDate[DateFull])

For Previous Year

ComPY = CALCULATE([ComYTD], DATEADD(DimDate[DateFull], -1, YEAR))

For Previous Month change the last two measures to TOTALMTD in the first of the two and the Interval YEAR to MONTH in the 2nd measure of the two

Thanks

Joe

If this post helps, then please Accept it as the solution