DatesMTD query help please ?

[Anonymous]

HI Team,

i have data set with 2 years of info

when i use datesMTD i get the current month info , which is great

However if an user selects 2-3 months, i does not work intutively ( only shows MTD as expected)

How can i make this formula more efficient?

so if an user selected 3 months, it totals those 3 months?

or

How can I use sub filter in caluclate so only the current FY is looked at , then i would not have to use MTD?

for the same reasom my Month/YTD switch also does not work

[lbendlin]

Those other months are fully in the past, so MTD is not required.  Or are you planning to compare these like-for-like, with the same number of days as in your current month?  (Which has all kinds of skewing issues, btw).