7days Rolling average showing wrong for Blank Columns

Question

Hi&nbsp;I have below data ..If i filter the Year from Year ,Month and weeknumber from respective filters i need to see data as below. For thatI have created 7D Rolling average measure which is giving some wrong values like if therse is no any wafer passed on May 4th respective 7D rolling average&nbsp; should show MAY 3rd Rolling average means 75.61 should show for May 4th also but there calculation is wrong&nbsp;How can i fix it&nbsp;&nbsp;7D_Rolling Average =IF(&nbsp;&nbsp;&nbsp;&nbsp;ISFILTERED('YIELD'[QC_DATE_OUT]),ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VAR LAST_DATE = LASTDATE('YIELD'[QC_DATE_OUT].[Date])&nbsp;&nbsp;&nbsp;&nbsp;Var passes7 = calculate(sum(YIELD[WAFERPASS]),DATESBETWEEN('YIELD'[QC_DATE_OUT].[Date],DATEADD(LAST_DATE, -6, DAY),LAST_DATE))Var Total7 = calculate(sum(YIELD[TotalWafers]),DATESBETWEEN('YIELD'[QC_DATE_OUT].[Date],DATEADD(LAST_DATE, -6, DAY),LAST_DATE))RETURN divide(passes7,Total7))

greg_deckler · Answer

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
&nbsp;
Also, could you post sample data in text?&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Forum Discussion

7days Rolling average showing wrong for Blank Columns

1 Reply

Related content

Rolling 12M Average measure

Show multiple rolling average % Diff

Rolling accumulation

Rolling accumulation

3 Day Rolling Average - DAX