Q1) I'm trying to get a "Daily" budget figure to compare to my sales value.
Sum(Budget) / Day(MonthEnd(DateId)) will give me the figure I'm after, but only for the 1st of each month. I need that value in every day, for the applicable months
Q2) I'd also like a Rolling 30 daily sales average (if possible, in the example data below, utilising the June sales for the July rows that would require it). Accumulate 30 Steps Back won't work because of days with no sales and it won't look back into June.
1) Because of days with no sales (i.e. missing days), the row count does not lend itself to simple Above() expressions.
2) Unchecking the "Suppress zero || missing values" checkbox in Presentation tab is BAD because it shows all possible DateId values, despite selections (i.e. displays every day in my Calendar table)
2) Obviously, there are list box selections elsewhere filtering data, including, but not limited to, a [DateFinYear] field and a [DateMonthName] field which limit the DateId's shown in the straight table chart.