Calculate YOY , QOQ, MOM Calculations To Date.

Introduction
Quick functions are a great way to perform comparative analysis based on time periods. However there is no easy way to do a comparison to date. e.g. YTD vs YTD Last Year. e.g. If today is Sep 27, 2018 then we want to compare  Jan 01 - Sept 27, 2018  to Jan 01 - Sept 27, 2017
Instructions
Add the following custom column in your Elasticube. e.g. YTD Flag
1
2
3
4
CASE
WHEN DayOfYear([Date Field]) <= Dayofyear(NOW()) THEN 'Y'
ELSE 'N'
END
Use the Quick Functions as you would normally do, but this time add a filter for the YTD Flag and set the value to Y.