In a formula, i want to sum up some measures from the day before the date that is displayed as a dimension. I am using the following formula to calculate the current date. Also the date field is called: Activity_Date
I have already tried many formulas that are on this forum. Also i tried setting a variable for yesterday and use that variable in the set analysis. However i did not get it to work yet.
Yesterday is simply DateField-1 if your datefield is formatted as date type. But in calculations the field needs to be surrounded by aggregated functions like Max(Date)-1 else it calculates into null due to more than one value possible.