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!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.