https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3285674#M122135 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="109251" data-lia-user-login="LCarenzo" class="lia-mention lia-mention-user">LCarenzo</a>&nbsp;search part&nbsp;<SPAN>Month-over-month in the link&nbsp;<A href="https://www.daxpatterns.com/standard-time-related-calculations/" target="_self">https://www.daxpatterns.com/standard-time-related-calculations/</A>&nbsp;</SPAN></P><P><SPAN>"month is in the same column" is good <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></P><P><SPAN>I hope this help</SPAN></P> Thu, 15 Jun 2023 10:03:28 GMT some_bih 2023-06-15T10:03:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3284450#M122077 <P>I am stuck.&nbsp; I have the following columns:</P><P>&nbsp;</P><P>Month</P><P>Value</P><P>Category</P><P>&nbsp;</P><P>I am trying to take last months value and subtract it from this months value - I want to be able to sort it by the category.&nbsp; Basically I am looking for the month over month difference, but the issue is my month is in the same column.</P><P>&nbsp;</P><P>How can I set this up to properly show the difference?</P><P>&nbsp;</P><P>Thanks in advance.</P><P>&nbsp;</P> Wed, 14 Jun 2023 19:53:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3284450#M122077 LCarenzo 2023-06-14T19:53:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3285674#M122135 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="109251" data-lia-user-login="LCarenzo" class="lia-mention lia-mention-user">LCarenzo</a>&nbsp;search part&nbsp;<SPAN>Month-over-month in the link&nbsp;<A href="https://www.daxpatterns.com/standard-time-related-calculations/" target="_self">https://www.daxpatterns.com/standard-time-related-calculations/</A>&nbsp;</SPAN></P><P><SPAN>"month is in the same column" is good <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></P><P><SPAN>I hope this help</SPAN></P> Thu, 15 Jun 2023 10:03:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3285674#M122135 some_bih 2023-06-15T10:03:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3294636#M122703 <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="109251" data-lia-user-login="LCarenzo" class="lia-mention lia-mention-user">LCarenzo</a>,</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> Wed, 21 Jun 2023 05:57:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3294636#M122703 Anonymous 2023-06-21T05:57:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3294734#M122712 <P>VAR currentMonth = [Month]<BR />VAR currentvalue = [Value]<BR />VAR perviousmonthvalue =&nbsp;CALCULATE(<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX([Value]), FILTER(ALL('TableName'),<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Category] = EARLIER([Category],&nbsp;<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Month] &lt;currentMonth<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; currentvalue - perviousmonthvalue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Wed, 21 Jun 2023 06:42:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide/m-p/3294734#M122712 devanshi 2023-06-21T06:42:16Z