This content has been marked as final.
Show 1 reply
-
1. Re: How to compare MTD and Last year MTD
Norbert MaijoorOct 26, 2017 4:45 AM (in response to monika sheoran)
Hi Monika,
Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.
1. today LY: DATEADD('year',-1,today())
2. MTD: if DATEDIFF('month',[date],today())=0 and [date]<today() then [value] END
3. MTD LY: if DATEDIFF('month',[date],[Today LY])=0 and [date]<[Today LY] then [value] END
4. up/down: if sum([MTD])<sum([MTD LY]) then "down" else "up" END
5. YTD: if DATEDIFF('year',[date],today())=0 and [date]<today() then [value] END
6. YTD LY: if DATEDIFF('year',[date],[Today LY])=0 and [date]<[Today LY] then [value] END
7. up/down Y: if sum([YTD ])<sum([YTD LY ]) then "down" else "up" END
Regards,
Norbert
-
MTD MTD LY_nalmai_10.3.twbx 26.1 KB
-