Hello All,
Is there a way to reference previous quarters only once they are completed - ie with 3 full months of data?
I reference data by quarter on a dashboard but I don't want it to start recognizing a quarter until it has 3 month of data in it.
Dropping my data dimension into the filter and using relative dates will pull in a new quarter once I hit the subsequent month. My data loads in monthly on a lag of about 2 weeks into the following month.
Any ideas or advise would be greatly appreciated.
Many thanks,
Darren
Hey Darren,
You could use a combination of COUNTD(Month(Date)) and throw that onto the filters in order to remove the incomplete quarter.
Take a look at the attached workbook and see if that helps!
For reference, W/O Filter contains the incomplete Q4 2018 data and With Filter removes the incomplete quarter.
