https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655174#M78433 <P>Please explain in details with screenshots</P> Fri, 22 Jul 2022 08:52:45 GMT tamerj1 2022-07-22T08:52:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2653212#M78289 <P>I&nbsp; Have two excel which&nbsp; i have imported into Power bi .&nbsp; one table name called&nbsp; FINAL another table name called&nbsp; Template.</P><P>&nbsp;</P><P><STRONG>FINAL</STRONG>&nbsp;</P><P>&nbsp;</P><P>Month&amp;Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Quantity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>&nbsp;</P><P>June 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ITGH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp;--&nbsp; taking this value compare to all the months in template sheet .</P><P>July&nbsp; 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CH01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33&nbsp;</P><P>August 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CZ01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45</P><P>September 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RZ01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 56</P><P>October 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LT01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>November 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS7Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 65</P><P>December 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DE19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23</P><P>January 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ITGF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 67&nbsp;&nbsp;</P><P>Feburary 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NL07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 78</P><P>March 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PLO2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23</P><P>&nbsp;</P><P>I&nbsp; taking to July month quanity Sum from Final sheet&nbsp; this value compare to all months in Template sheet&nbsp;</P><P><STRONG>Template</STRONG>&nbsp;</P><P>&nbsp;</P><P>Month&amp;Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Quantity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>&nbsp;</P><P>June 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ITGH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24</P><P>July&nbsp; 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CH01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 53&nbsp;</P><P>August 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CZ01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 65</P><P>September 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RZ01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 26</P><P>October 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LT01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;44</P><P>November 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS7Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75</P><P>December 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DE19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33</P><P>January 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ITGF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 87&nbsp;&nbsp;</P><P>Feburary 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NL07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 58</P><P>March 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PLO2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23</P><P>&nbsp;</P><P>&nbsp;</P><P>Final Result :</P><P>Month&amp;Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Quantity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;July val finalsheet&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;increase /Decrease&nbsp;</P><P>&nbsp;</P><P>June 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ITGH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10</P><P>July&nbsp; 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CH01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 53&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19</P><P>August 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CZ01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 65&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31</P><P>September 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RZ01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -8</P><P>October 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LT01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;44&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>November 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS7Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31</P><P>December 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DE19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1</P><P>January 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ITGF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 87&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 53</P><P>Feburary 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NL07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 58&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24</P><P>March 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PLO2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-11</P><P>&nbsp;</P><P>How to compare month on month&nbsp; FINAL sheet june&nbsp; value to all the months in template sheet .</P><P>looking for support . thanks in advance&nbsp;</P> Thu, 21 Jul 2022 13:00:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2653212#M78289 Anonymous 2022-07-21T13:00:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2653336#M78301 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;<BR />Here is a sample file with the solution&nbsp;<A href="https://www.dropbox.com/t/ukAb0PlQWRb6N4BA" target="_blank">https://www.dropbox.com/t/ukAb0PlQWRb6N4BA</A></P><P><img /><img /></P><LI-CODE lang="javascript">QTY = SUM ( Template[Quantity] )</LI-CODE><LI-CODE lang="javascript">July val finalsheet = SUMX ( VALUES ( Template[Month&amp; Year] ), CALCULATE ( SUM ( FINAL[Quantity] ), FINAL[Month&amp; Year] = MIN ( FINAL[Month&amp; Year] ) ) )</LI-CODE><LI-CODE lang="javascript">increase/Decrease = [QTY] - [July val finalsheet]</LI-CODE> Thu, 21 Jul 2022 13:39:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2653336#M78301 tamerj1 2022-07-21T13:39:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2653438#M78305 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp; thank you&nbsp; so much&nbsp;</P> Thu, 21 Jul 2022 14:18:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2653438#M78305 Anonymous 2022-07-21T14:18:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2654964#M78416 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp; one more question . how to change it&nbsp; to month on month comparision instead july month .compare month on month compare&nbsp; like&nbsp; below</P><P>&nbsp;</P><P>July - july&nbsp;</P><P>August - August&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 22 Jul 2022 07:19:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2654964#M78416 Anonymous 2022-07-22T07:19:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655071#M78424 <P>Anonymous</a>&nbsp;<BR />Yes can be done. But I have a question; in your sample data there is only one plant for each month. Is this the case in the real data?&nbsp;</P> Fri, 22 Jul 2022 08:07:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655071#M78424 tamerj1 2022-07-22T08:07:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655105#M78425 <P>Anonymous</a>&nbsp;<BR />Please check the following on your real data and let me know if it works or something else need to be done.&nbsp;</P><P><img /></P> Fri, 22 Jul 2022 08:16:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655105#M78425 tamerj1 2022-07-22T08:16:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655135#M78429 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp; Sir there is&nbsp; multiple plant for each month sir.&nbsp; &nbsp;after made the relatioship between two table&nbsp; &nbsp;date wise working afte add plant&nbsp; one sheet quanity its showing same&nbsp; value for all month</P> Fri, 22 Jul 2022 08:33:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655135#M78429 Anonymous 2022-07-22T08:33:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655174#M78433 <P>Please explain in details with screenshots</P> Fri, 22 Jul 2022 08:52:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655174#M78433 tamerj1 2022-07-22T08:52:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655202#M78435 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp; sir i have added data set file in pbix for your&nbsp; reference .&nbsp;<A title="Sample PBIX file" href="https://drive.google.com/file/d/1FgeWDnnDAck1SMcH2-LDW-EAb_jnezRq/view?usp=sharing" target="_self">https://drive.google.com/file/d/1FgeWDnnDAck1SMcH2-LDW-EAb_jnezRq/view?usp=sharing</A>&nbsp;</P> Fri, 22 Jul 2022 09:01:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655202#M78435 Anonymous 2022-07-22T09:01:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655285#M78437 <P>Hi&nbsp;Anonymous</a>&nbsp;<BR />I hope this is what you need&nbsp;<A href="https://www.dropbox.com/t/HNgMILjEZ8o8ZmU3" target="_blank">https://www.dropbox.com/t/HNgMILjEZ8o8ZmU3</A></P><P><img /><img /></P> Fri, 22 Jul 2022 09:41:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2655285#M78437 tamerj1 2022-07-22T09:41:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2658102#M78694 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp; thank you so much but i am getting single month multiple time sir. i want only one month&nbsp;</P> Mon, 25 Jul 2022 06:04:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2658102#M78694 Anonymous 2022-07-25T06:04:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2658143#M78698 <P>Hi&nbsp;Anonymous</a>&nbsp;</P><P>please explain and clarify in details with screenshots and markups</P> Mon, 25 Jul 2022 06:27:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2658143#M78698 tamerj1 2022-07-25T06:27:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2658237#M78708 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp; &nbsp;i am trying to change number to Million in Matrix visual but there is no option to change million format . i have created new measure and calcualted column both&nbsp;</P><P>&nbsp;</P><DIV><DIV><STRONG>MILLION= FORMAT(SUM(template[Quantity]), "#,,.0M")</STRONG></DIV><DIV>&nbsp;</DIV><DIV><DIV><STRONG>Measure = FORMAT(SUM(template[Quantity]), "#,,.0M")</STRONG></DIV><DIV>&nbsp;</DIV><DIV>So&nbsp; i have added in that two measure and calcualted column its showing like&nbsp; below&nbsp;</DIV><DIV>&nbsp;</DIV><DIV><img /><P>but i am using input sheet column its showing correct like below screen shot&nbsp;</P><img /><P>&nbsp;</P><BR /><P>&nbsp;</P></DIV></DIV></DIV> Mon, 25 Jul 2022 07:13:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-On-Month-Comparison-between-two-sheets-for-current-month/m-p/2658237#M78708 Anonymous 2022-07-25T07:13:05Z