MTD and LY MTD help
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" ) ) ) Anonymous Thanks in advance
