https://community.fabric.microsoft.com/t5/Report-Server/average/m-p/289098#M1646 <P>I Have the following query. I would like to calculate the average of 1st attempt of the column KPI EXIT. The thing is, every row has a diferent date like 1-01-2017. How can I get the average per month up to the date I want.&nbsp;<img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 24 Oct 2017 15:23:14 GMT pbi1 2017-10-24T15:23:14Z https://community.fabric.microsoft.com/t5/Report-Server/average/m-p/289098#M1646 <P>I Have the following query. I would like to calculate the average of 1st attempt of the column KPI EXIT. The thing is, every row has a diferent date like 1-01-2017. How can I get the average per month up to the date I want.&nbsp;<img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 24 Oct 2017 15:23:14 GMT https://community.fabric.microsoft.com/t5/Report-Server/average/m-p/289098#M1646 pbi1 2017-10-24T15:23:14Z https://community.fabric.microsoft.com/t5/Report-Server/average/m-p/289675#M1657 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="44768" data-lia-user-login="pbi1" class="lia-mention lia-mention-user">pbi1</a>,</P> <P>&nbsp;</P> <P>The [KPI EXIT] is a text column, how to calculate the average for "1st attempt"?</P> <P>&nbsp;</P> <P>Based on my assumption, you want to calculate based on an other numeric field per month, right? If so, please create a column similar to below:</P> <P><STRONG>Average=CALCULATE(AVERAGE(TableName[Numeric Column]), FILTER(ALLEXCEPT(TableName,TableName[Date].Month), TableName[KPI EXIT]="1ST ATTEMPT"))</STRONG></P> <P>&nbsp;</P> <P>If I have something misunderstood, please provide more detailed data and show us your desired result.</P> <P>&nbsp;</P> <P>Regards,<BR />Yuliana Gu</P> Wed, 25 Oct 2017 08:37:15 GMT https://community.fabric.microsoft.com/t5/Report-Server/average/m-p/289675#M1657 v-yulgu-msft 2017-10-25T08:37:15Z