Moving average excluding days without data

Question

Hello,&nbsp;&nbsp;I have this chart with moving average. I dont want to see 4th and 5th day because theres no data (theres more date without data, 4th and 5th is for example). I have no clue what to do.&nbsp;Its from calculated measure from two tables:&nbsp;Table1: date, hours1Table2: date, hours2(In those tables arent days with null or blank spaces.)&nbsp;calculated measure: Produtivität = hours1/hours2&nbsp;Moving average % =averagex(&nbsp; &nbsp; FILTER(ALLSELECTED(Kalender),&nbsp; &nbsp; Kalender[Datum] &lt;= MAX(Kalender[Datum])),&nbsp; &nbsp; &nbsp; &nbsp; [Produktivität])&nbsp;

wdx223_daniel · Accepted Answer

Moving average % =IF(&nbsp;[Produktivität],

averagex(
&nbsp; &nbsp;&nbsp;FILTER(ALLSELECTED(Kalender),
&nbsp; &nbsp;&nbsp;Kalender[Datum]&nbsp;&lt;=&nbsp;MAX(Kalender[Datum])),
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;[Produktivität]))

Forum Discussion

Moving average excluding days without data

2 Replies

Related content

Average excluding zero's

Average excluding 0

Help Calculating Average Excluding 2 Conditions

Average for Month Excluding Current Month

Average and Moving Average