topic Re: Average of selected dates in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-selected-dates/m-p/3161461#M113556 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="497279" data-lia-user-login="prashantg364" class="lia-mention lia-mention-user">prashantg364</a>&nbsp;</P><P>You can create three separate measures, each referencing a task column. For example, Task 1:</P><LI-CODE lang="markup">average_task_1 = AVERAGE ( 'Table'[Task1] )</LI-CODE><P>&nbsp;The measure automatically takes into account the date selection.</P> Wed, 29 Mar 2023 16:43:43 GMT Barthel 2023-03-29T16:43:43Z Average of selected dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-selected-dates/m-p/3161408#M113554 <P>Below is my data set.</P><P>I want to calculate an average of Task1, Task2, and Task3 for any particular date range.</P><P>&nbsp;</P><P>like for example&nbsp;</P><P>Date range 20-03-2023 to 25-03-23</P><P>Average of Task1 = 275</P><P>Average of Task2 = 288</P><P>Average of Task3 = 399<BR /><BR /></P><P>What measure should I create to get this Average?</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Task1</TD><TD>Task2</TD><TD>Task3</TD></TR><TR><TD>16-03-2023</TD><TD>239</TD><TD>373</TD><TD>388</TD></TR><TR><TD>17-03-2023</TD><TD>255</TD><TD>288</TD><TD>439</TD></TR><TR><TD>18-03-2023</TD><TD>260</TD><TD>222</TD><TD>448</TD></TR><TR><TD>19-03-2023</TD><TD>9</TD><TD>24</TD><TD>50</TD></TR><TR><TD><FONT color="#FF0000">20-03-2023</FONT></TD><TD><FONT color="#FF0000">300</FONT></TD><TD><FONT color="#FF0000">272</FONT></TD><TD><FONT color="#FF0000">331</FONT></TD></TR><TR><TD><FONT color="#FF0000">21-03-2023</FONT></TD><TD><FONT color="#FF0000">265</FONT></TD><TD><FONT color="#FF0000">242</FONT></TD><TD><FONT color="#FF0000">354</FONT></TD></TR><TR><TD><FONT color="#FF0000">22-03-2023</FONT></TD><TD><FONT color="#FF0000">298</FONT></TD><TD><FONT color="#FF0000">308</FONT></TD><TD><FONT color="#FF0000">500</FONT></TD></TR><TR><TD><FONT color="#FF0000">23-03-2023</FONT></TD><TD><FONT color="#FF0000">307</FONT></TD><TD><FONT color="#FF0000">338</FONT></TD><TD><FONT color="#FF0000">434</FONT></TD></TR><TR><TD><FONT color="#FF0000">24-03-2023</FONT></TD><TD><FONT color="#FF0000">219</FONT></TD><TD><FONT color="#FF0000">295</FONT></TD><TD><FONT color="#FF0000">436</FONT></TD></TR><TR><TD><FONT color="#FF0000">25-03-2023</FONT></TD><TD><FONT color="#FF0000">263</FONT></TD><TD><FONT color="#FF0000">276</FONT></TD><TD><FONT color="#FF0000">343</FONT></TD></TR><TR><TD>26-03-2023</TD><TD>75</TD><TD>47</TD><TD>125</TD></TR><TR><TD>27-03-2023</TD><TD>299</TD><TD>352</TD><TD>633</TD></TR><TR><TD>Grand Total</TD><TD>2789</TD><TD>3037</TD><TD>4481</TD></TR></TBODY></TABLE> Wed, 29 Mar 2023 16:12:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-selected-dates/m-p/3161408#M113554 prashantg364 2023-03-29T16:12:03Z Re: Average of selected dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-selected-dates/m-p/3161461#M113556 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="497279" data-lia-user-login="prashantg364" class="lia-mention lia-mention-user">prashantg364</a>&nbsp;</P><P>You can create three separate measures, each referencing a task column. For example, Task 1:</P><LI-CODE lang="markup">average_task_1 = AVERAGE ( 'Table'[Task1] )</LI-CODE><P>&nbsp;The measure automatically takes into account the date selection.</P> Wed, 29 Mar 2023 16:43:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-selected-dates/m-p/3161461#M113556 Barthel 2023-03-29T16:43:43Z