Sum of rolling backward between now and a fixed period in the past

[Anonymous]

Hi All,

I try to calculate the total cost of our sales by item over a fixed period backwards in time. So my starting day is today and the ending day  is 1 year ago.  I already tried this, bud it is not working. Help would be appreciated.

Thanks in advance,

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure

Measure = CALCULATE(SUM(Sheet1[value]),DATESINPERIOD('caledar date'[Date],TODAY(),-1,YEAR))

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.