Forum Discussion

JemmaD's avatar
JemmaD
Icon for Helper V rankHelper V
2 years ago

Calculation Group to filter dates

Hi experts! I have a table of data counting meetings by date.  The report consumers want to filter this table by Previous YTD, Previous QTD, Previous MTD, next YTD, next QTD and next MTD. I thin...
Need Help
JemmaD's avatar
JemmaD
Icon for Helper V rankHelper V
2 years ago

devesh_gupta thanks for replying. I'm getting a syntax error with that measure and I can't figure out where to correct it:

 

devesh_gupta's avatar
devesh_gupta
Icon for Impactful Individual rankImpactful Individual
2 years ago

JemmaD In that case, the way you were creating the measures earlier was looking fine and it should work as expected but I'm not sure why those measures were not filtering dates for you.

 

In your 'Dates' table, ensure that there is a hierarchy set up correctly for Year, Quarter, and Month. This is crucial for the functions like DATESYTD, DATESQTD, and DATESMTD to work as expected.

 

Thanks!