For a Actual vs Forecasting table, I am trying to extract the Maximum Date of Actuals, or even the Minimum Date of Forecasting to then do a cumulative value.
The intention is to have two lines that do not overlap. So for the last 3 months, the Actuals Cumulative would not be a straight line (due to 0 rolling sum), and would cut off at the Maximum Actual Date.
I have done this formula multiple times, storing that date in a Variable, to then reference in a Calculate formula to sum all values less than that date.
The Variable for the date is storing the filters used of Type = Actuals, or Forecast and any other conditions I may apply, when I have never had this before since the Variable is meant to be independant and return a scalar or table result.
Can an answer be provided as to why the Variable is sotring filter conditions, rather than applying the scalar value of date that I need?
mattlee
on:
Problem : Data labels stacked bar chart