Forum Discussion
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...
devesh_gupta thanks for replying. I'm getting a syntax error with that measure and I can't figure out where to correct it:
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!