https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3219382#M117624 <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="460979" data-lia-user-login="sara_pinto15" class="lia-mention lia-mention-user">sara_pinto15</a>&nbsp;,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">If these also don't help, please share more detailed information and description to help us clarify your scenario to test.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;"><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly&nbsp;</A></P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Regards,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Xiaoxin Sheng</P> Thu, 04 May 2023 07:26:58 GMT Anonymous 2023-05-04T07:26:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3207734#M116896 <P>Hello. I hope they're all well.<BR />I want to calculate the total number of months accumulated with consumption. How can I do it?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank you! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Wed, 26 Apr 2023 17:03:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3207734#M116896 sara_pinto15 2023-04-26T17:03:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3208435#M116942 <P>NewMeasure=<SPAN>ROWNUMBER</SPAN><SPAN>(</SPAN><SPAN>SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(Sales</SPAN><SPAN>),</SPAN><SPAN>Dates</SPAN><SPAN>[Year],Dates[Month]</SPAN><SPAN>),</SPAN><SPAN>ORDERBY</SPAN><SPAN>(</SPAN><SPAN>Dates</SPAN><SPAN>[Year],ASC,Dates[Month],ASC</SPAN><SPAN>))</SPAN></P> Thu, 27 Apr 2023 04:57:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3208435#M116942 wdx223_Daniel 2023-04-27T04:57:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3219382#M117624 <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="460979" data-lia-user-login="sara_pinto15" class="lia-mention lia-mention-user">sara_pinto15</a>&nbsp;,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">If these also don't help, please share more detailed information and description to help us clarify your scenario to test.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;"><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly&nbsp;</A></P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Regards,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Xiaoxin Sheng</P> Thu, 04 May 2023 07:26:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3219382#M117624 Anonymous 2023-05-04T07:26:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3272474#M121342 <P>Thank you! <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Wed, 07 Jun 2023 11:20:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Number-of-months-with-sales/m-p/3272474#M121342 sara_pinto15 2023-06-07T11:20:20Z