Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DatesMTD query help please ?

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

 

 

Need Help
Show and Tell

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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).