The average of a trailing average

[benhoward00]

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.

[some_bih]

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