I am developing a cumulative total for the attached model, i have different forecast and actual versions.
My cumulative total works for 2020 Budget and 2020 Forecast but does not work for Prior Year 2019.
i have created three total sales formula= Current year forecast, Current year budget and Prior year actuals. I am now trying to run the cumulative totals for the three total sales measures.
i am using dateadd ( allselected) in the cumulative sales formula. What i am not able to crack is it works for Current year budget and forecast when i select year 2020. and Prior year works when i select year 2019. But when i select both the year it does not work for the Prior year actuals.
my selection slicer year is 2020 and 2019
May i know where i am going wrong.
Appreciate your help.
KrishBI Time Intelligence Issue.xlsx (9.3 KB)