topic Re: Swap SUM Total for AVG per month in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Swap-SUM-Total-for-AVG-per-month/m-p/2251794#M54236 <P>Wow! Thanks again very much!</P> Wed, 22 Dec 2021 10:35:14 GMT Lyle 2021-12-22T10:35:14Z Swap SUM Total for AVG per month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Swap-SUM-Total-for-AVG-per-month/m-p/2251613#M54225 <P>I'm trying to create a measure for changing the SUM Total to an AVG over 12 months (1 year). I'd like to have the right table saying:</P><P>&nbsp;</P><P>2019 IN = 93 / 12 = 7.75</P><P>&nbsp;</P><P><A href="https://contraconsolidations-my.sharepoint.com/:x:/g/personal/dylan_contracon_net/EWT43eddu05EqoXXCZCssPUBuUF9VGfqydvy0JQ_mwmeDA?e=735Utt" target="_blank">https://contraconsolidations-my.sharepoint.com/:x:/g/personal/dylan_contracon_net/EWT43eddu05EqoXXCZCssPUBuUF9VGfqydvy0JQ_mwmeDA?e=735Utt</A></P><P><A href="https://contraconsolidations-my.sharepoint.com/:u:/g/personal/dylan_contracon_net/EUyVS6LezIJFkwr0oh29dM8B_gO85SVipMqjxoW1ICvtVw?e=w2JfHT" target="_blank">https://contraconsolidations-my.sharepoint.com/:u:/g/personal/dylan_contracon_net/EUyVS6LezIJFkwr0oh29dM8B_gO85SVipMqjxoW1ICvtVw?e=w2JfHT</A></P><P>&nbsp;</P><P>Thanks in advance!</P><P>Anonymous</LI-USER>&nbsp;you previously helped me with something similar:</P><P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/Measure-from-current-month-amp-year-to-the-same-month-from-the/m-p/2212117#M52225" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/Measure-from-current-month-amp-year-to-the-same-month-from-the/m-p/2212117#M52225</A></P><P>&nbsp;</P> Wed, 22 Dec 2021 09:20:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Swap-SUM-Total-for-AVG-per-month/m-p/2251613#M54225 Lyle 2021-12-22T09:20:05Z Re: Swap SUM Total for AVG per month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Swap-SUM-Total-for-AVG-per-month/m-p/2251675#M54227 <P>HI&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="341975" data-lia-user-login="Lyle" class="lia-mention lia-mention-user">Lyle</a>&nbsp;,</P> <P>&nbsp;</P> <P>1. Create a Date Table .&nbsp;</P> <P><A href="https://www.youtube.com/watch?v=mLiPm82GRUo" target="_blank" rel="noopener">https://www.youtube.com/watch?v=mLiPm82GRUo</A></P> <P>&nbsp;</P> <P>2. Create a measure</P> <DIV> <DIV><SPAN>Total Trips = SUM(Box[Trips])</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>3. Create a measure&nbsp;</SPAN></DIV> <DIV> <DIV> <DIV><SPAN>Average Trips/month = AVERAGEX(VALUES(Dates[MonthnYear]), [Total Trips])</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>.pbix attached</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>Regards,</SPAN></DIV> <DIV><SPAN>Harsh Nathani</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><img /></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>Regards,<BR />Harsh Nathani<BR /><STRONG>Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)</STRONG></SPAN></DIV> </DIV> </DIV> </DIV> Wed, 22 Dec 2021 09:40:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Swap-SUM-Total-for-AVG-per-month/m-p/2251675#M54227 Anonymous 2021-12-22T09:40:38Z Re: Swap SUM Total for AVG per month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Swap-SUM-Total-for-AVG-per-month/m-p/2251794#M54236 <P>Wow! Thanks again very much!</P> Wed, 22 Dec 2021 10:35:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Swap-SUM-Total-for-AVG-per-month/m-p/2251794#M54236 Lyle 2021-12-22T10:35:14Z