Forum Discussion
Pawan
3 years agoFrequent Visitor
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