7 Days Rolling Average between 2016-2020

Question

Hi Experts&nbsp;The below measure gives me the correct average calculation for the period 2016-2020. How do i get the 7 day rolling average between thsoe datesmy Measure =2016-20 Average = VAR _A = &nbsp;SELECTEDVALUE(DimDate[Day of Year])RETURN&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Average('ce DemandDestructionSimple'[Value]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DimDate[Day of Year] = _A,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DimDate[Year] &gt;= 2016 &amp;&amp; DimDate[Year] &lt;= 2020,&nbsp; &nbsp; ALL( DimDate ))

grandtotal · Accepted Answer

Check out this article by SQLBI:https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/

Forum Discussion

7 Days Rolling Average between 2016-2020

2 Replies

Related content

Rolling 12M Average measure

3 Day Rolling Average - DAX

Rolling accumulation

Rolling accumulation

Conditional Rolling Average