MTD and LY MTD help

[Pawan]

Hi,

I have the requirement to calculate MTD, LY MTD based on below logics

MTD should show default month selection i.e., till today 23/1/2023 data need to display as default MTD value

LY MTD should show data upto 23/1/2022 as default LY MTD value

Note. User can select full year/quarter/month from below filter pane. based on selection MTD and LY MTD values need to change dynamically.

I have calculated MTD, LY MTDby using below expression with default month filter. Its working only for 2023 full year and all years jan selection. When i have slected 2022 feb then getting blank data in LY MTD value.

Please help me to write these logics.

MTD = CALCULATE( Sum(Sales[NetAmountGBP]), Sales[IsInternalOrder]=False,'Date'[CurrentDayOffset]<=0)

LY MTD = CALCULATE (

[MTD],

FILTER (

SAMEPERIODLASTYEAR ( 'Date'[Date] ),

FORMAT ( [Date], "MMDD" ) <= FORMAT ( TODAY (), "MMDD" )

)

)

@v-xinruzhu-msft 

Thanks in advance