I have a dataset where I have only three quarters in the most recent year. I want to calculate YoY (cumulative three current Q's over cumulative three previous Q's) growth for the latest period compared to same three quarters in the previous year. Is there a way of doing this dynamically, such that the calculation updates if new data is added? Also, is there a way to show them cumulatively (for a year) instead of Q1 and Q2?
I have researched and found this as a possible part of the solution. However, I would like to see the most recent date in the dataset instead of TODAY(). Is there a function for it?
IF DATEPART("quarter",[OrderDate]) <= DATEPART("quarter", TODAY()) THEN "YTD" ELSE "(After YTD)" END