https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-multiple-column-period-in-a-matrix/m-p/4104701#M162891 <P>Based on what you wrote I think you are looking for something like this...</P> <P><img /></P> <P>I have attached a pbix file that shows the measures I used.</P> <P>Hope this gets you pointed in the right direction.</P> Fri, 16 Aug 2024 17:08:17 GMT jgeddes 2024-08-16T17:08:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-multiple-column-period-in-a-matrix/m-p/4103937#M162848 <P>Hi all,&nbsp;</P><P>I'm tottaly newby in DAX and need certainly help for a basic commands.</P><P>I've got a Matrix that show the data consumption for each mobile subscription, I would like to create a new column to show the average of the data comsuption.&nbsp;</P><P>To built my matrix, I've got 2 tables.&nbsp;</P><P>- DATAs_Vol_Mob</P><TABLE><TBODY><TR><TD><STRONG>Period</STRONG></TD><TD><STRONG>Subscription</STRONG></TD><TD><STRONG>DATA Volume</STRONG></TD></TR><TR><TD>1.2024</TD><TD>4179xxxyy01</TD><TD>8935.663</TD></TR><TR><TD>1.2024</TD><TD>4179xxxyy02</TD><TD>8301.548</TD></TR><TR><TD>2.2024</TD><TD>4179xxxyy01</TD><TD>9035.663</TD></TR><TR><TD>2.2024</TD><TD>4179xxxyy02</TD><TD>8401.548</TD></TR><TR><TD>2.2024</TD><TD>4179xxxyy01</TD><TD>9035.663</TD></TR><TR><TD>3.2024</TD><TD>4179xxxyy02</TD><TD>8386.548</TD></TR></TBODY></TABLE><P>-&nbsp;Inventaire_Mobile</P><TABLE><TBODY><TR><TD><STRONG>Contrat lié</STRONG></TD><TD><STRONG>Référence du contrat</STRONG></TD><TD><STRONG>Utilisateur (login)</STRONG></TD></TR><TR><TD>4179xxxyy01</TD><TD>NATEL® go flex Swiss premium XS</TD><TD>USER#1</TD></TR><TR><TD>4179xxxyy02</TD><TD>NATEL® go flex Swiss premium M</TD><TD>USER#2</TD></TR></TBODY></TABLE><P>A link between the 2 tables in&nbsp;</P><P><img /></P><P>The result I want should be :</P><TABLE border="1"><TBODY><TR><TD><STRONG>Utilisateur (login)</STRONG></TD><TD><STRONG>Référence du contrat</STRONG></TD><TD><STRONG>&nbsp;Subscription</STRONG></TD><TD><STRONG>1.2024</STRONG></TD><TD><STRONG>2.2024</STRONG></TD><TD><STRONG>3.2024</STRONG></TD><TD><STRONG>TOTAL</STRONG></TD><TD><STRONG>Average [based on all period]</STRONG></TD><TD><STRONG>Average of the data consumption of all subscrption of the "Reference du contrat)</STRONG></TD></TR><TR><TD>USER#1</TD><TD>NATEL® go flex Swiss premium XS</TD><TD>4179xxxyy01</TD><TD>8935.663</TD><TD>9035.663</TD><TD>9035.663</TD><TD>27006.99</TD><TD>9002.33</TD><TD>?</TD></TR><TR><TD>USER#2</TD><TD>NATEL® go flex Swiss premium M</TD><TD>4179xxxyy02</TD><TD>8301.548</TD><TD>8401.548</TD><TD>8386.548</TD><TD>25089.64</TD><TD>8363.21</TD><TD>?</TD></TR></TBODY></TABLE><P>Average [based on all period] = Average of the 3 current period (1.2024 | 2.2024 | 3.2024). Next periods will be added later on.&nbsp;</P><P>Last column should be the average of all subscription per "reference contrat" as I have ~1500 subsriptions.&nbsp;</P><P>&nbsp;</P><P>I tried to use "Quick Mesure" but the result is not the one I want.</P><P>I want also update all month the data for the current period, as I will run this repport on a long terms, having average per year will be a must.&nbsp;</P><P>&nbsp;</P><P>Thanks for your futur support</P><P>&nbsp;</P> Fri, 16 Aug 2024 08:58:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-multiple-column-period-in-a-matrix/m-p/4103937#M162848 Anonymous 2024-08-16T08:58:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-multiple-column-period-in-a-matrix/m-p/4104701#M162891 <P>Based on what you wrote I think you are looking for something like this...</P> <P><img /></P> <P>I have attached a pbix file that shows the measures I used.</P> <P>Hope this gets you pointed in the right direction.</P> Fri, 16 Aug 2024 17:08:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-multiple-column-period-in-a-matrix/m-p/4104701#M162891 jgeddes 2024-08-16T17:08:17Z