Forum Discussion

Pawan's avatar
Pawan
Frequent Visitor
3 years ago

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
 
No RepliesBe the first to reply