The average of a trailing average

benhoward00 — Wed, 14 Jun 2023 15:55:31 GMT

Hello,

I am calculating the trailing average of a value, [30 day trailing average] and this is working fine and I can choose the offset etc by using the Window function (our data can arrive upto a week late, so I have in effect to ignore the last week.

What I then need to do is to determine the average of the [30 day trailing average] measure, again, ignoring the last two weeks and looking back over 30 days (so effectively days -14 to -43 from today. I need to return a single scalar value for this. The image below is a screenshot of the data when dumped into Excel.

I cannot post a copy of the data as the dates do not come through properly 😞 . I have a date table of course just called Date.

Thanks in advance, Ben.

Re: The average of a trailing average

some_bih — Thu, 15 Jun 2023 10:06:08 GMT

Hi benhoward00 check link https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/ I hope this helps you.

topic Re: The average of a trailing average in DAX Commands and Tips

The average of a trailing average

Re: The average of a trailing average