Moving Average calculated from "today"

[AndyC]

Hi everyone,

I've got a moving average measure:

30 Day Moving Average = 
AVERAGEX (
DATESINPERIOD (
'Date'[Date],
LASTDATE ( 'Date'[Date] ),
-30,
DAY
),
[Total Stream]
)

and I was wondering how to only calculate it back from the current day as at the moment it projects another 30 days onto a line chart.

Many thanks

[Phil_Seamark · Accepted solution]

One suggestion is to add a column to your date table as follows

Days from Today = INT(NOW() - Dates[Date])

Then you can simply add a Visual, Page or Report filter that only shows data for when [Days from Today] is > 0 (or between a range)

There are other benefits to adding such a column - so I highly recommend.

[AndyC]

Thanks for the reply.  I ended up using the "Age" function on a duplicate of the date column and selected "Day" as the granularity.