1 of 1 people found this helpful
Try wrapping your calculation in an IF statement as shown
It will return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for the response Jim!
That gets me a little closer (I think I was missing the min before the date to get the if statement working).
Unfortunately, I still need that Baseline (the purple line) to go to the end but this is a very helpful start!
For context, customer agrees to a plan in Jan (Baseline) then can adjust that plan as the year goes (Planned) and they want to see how they do compared to both (Actual).
Glad you got it