Measure - values for 1 month ago to today

[Anonymous]

Hi

I need to create a measure that calculates all values on a daily basis for all dates from (today minus 1 month) up to today. Tried DATEADD and MONTH functions but can't get it to work. Any help appreciated. Thanks.

[amitchandak · Accepted solution]

@Anonymous , Try a measure like this

Rolling = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],today(),-1,MONTH))

or

Rolling = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],today(),-30,Day))