Forum Discussion
Adrianna
8 years agoRegular Visitor
Incomplete data for YoY%
Hey! I am trying to visualize yearly change of the value. I encountered one problem, everything works fine until I get to the 2018. I've got missing data from April 2018 and it keeps on lowering...
dani0010
8 years agoAdvocate II
I encounter similar situations frequently, and my pattern is to always create a measure which I call Pivot Date. Pivot Date contains the latest date of historical data. Use whatever logic you need to arrive at this date. Then you can use a statement like min(pivot date, max(date dimension)) to filter your dates to the proper cutoff. This will work properly for prior and current years.
Pivot Date is very handy for doing prior period to-date calculations or if you're doing forecasting and need future dates in your calendar but also need to keep track of the cutoff of historical actuals.