A table would look like this with monthly targets. What is the YTD target on April 5. that measure would return the TotalYTD for the first 3 months + 5 days worth of April target = 94 (29+29+29+43*(5/30)
A simple way to get close is to do (TotalYTD for the targetcolumn*12 (no of months)*daynumberofyear)/monthno), but it will not be exact in any way
Thx for your help. Not totally sure I understand your syntax. I have tried applying it to my data but I cannot get it to return anything meaningful so maybe it just does not fit with my data per above.