Using a date field to present today()-1 date for a measure values on a column instead of filter. Cannot use filtering due to other fields populating data for the continuous time period.
I have daily accumulating sum which gets rolled up on a daily basis. A calculated column is required which looks at the previous day and populates the sum of the measure field accordingly. I have tried several examples (as below) to no real avail. Would appreciate some insight into how best to do this. I have tried others but am drawing 0's. I have verified the records exists when using the [Participants] field directly
WHEN [Participants_date -1]
IF attr(Participants]) = ATTR(INT([Participants -1]))
Here is what I would use in your case:
IF [Date]=TODAY()-1 THEN [Participants] END
Let me know if this doesn't work and maybe you could upload a package workbook.