Sum of last year MTD

[Anonymous]

Hi Guys, 

I would like to find out the MTD sum of [TEU] but for last year instead. I have tried 

TEU_MTDLAST = CALCULATE([Total_TEU], SAMEPERIODLASTYEAR(DATESMTD(DateTable[Date]))) but it gives me the sum of the entire month of last year. For better visualisation, this is the sample data set: 

My code gives me a sum of 100190 TEUes (which is the sum of 1/6/2022 to 9/6/2022). However, since today's date is 6/6/2023, I want to get the sum of TEU from 1/6/2022 to 6/6/2022 only. 

[Mahesh0016]

@Anonymous 

MTD =

CALCULATE (

    TOTALMTD ( SUM ( 'Table'[Value] ), 'Table'[Date] ),

    FILTER ( ALLSELECTED('Table'[Year]), 'Table'[Year] < MAX ( 'Table'[Year] ) )

)

@Anonymous I hope this help you ! THANK YOU !!

[Anonymous]

Unfortunately, I am still getting the same number (100190 TEUs), which is not what I am looking for.