I've got a moving average measure:
30 Day Moving Average =
LASTDATE ( 'Date'[Date] ),
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.
Go to 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.
Proud to be a Datanaut!
View solution in original post
Thanks for the reply. I ended up using the "Age" function on a duplicate of the date column and selected "Day" as the granularity.
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!