topic Re: Create Matrix or Table with compare data between dates in PowerBi in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4710511#M180397 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1282814" data-lia-user-login="Someone22" class="lia-mention lia-mention-user">Someone22</a>,</P> <P>&nbsp;</P> <P><SPAN>Thank you for reaching out to Microsoft Fabric Community.</SPAN></P> <P>&nbsp;</P> <P>Based on your description, please follow below steps:</P> <UL> <LI>Open Power Query Editor select all month columns (2025.May to 2025.September) and click Unpivot Columns.</LI> <LI>Sort the Days column in descending order.</LI> <LI>Go to Add Column --&gt; Index Column and add a custom index column from 0 and name it as Index.</LI> <LI>Duplicate the table and name it PreviousRow and rename its Index column to PreviousIndex.</LI> <LI>And merge the original table with PreviousRow, on Month = Month and on Index = PreviousIndex + 1.</LI> <LI>Expand the merged table and extract the previous demand value.</LI> <LI>After the merge create a new column to calculate the difference:<BR />= [Demand] - [PreviousRow.Demand]</LI> <LI>Click Close &amp; Apply and load the data back to power bi.</LI> <LI>Create a Matrix visual and use Days in Rows, Month in Columns and calculated difference in Values.</LI> </UL> <P>This matrix will now show the demand changes compared to the previous snapshot date for each month.</P> <P>&nbsp;</P> <P>If this post&nbsp;helps, then please consider<SPAN>&nbsp;<STRONG>Accepting as solution&nbsp;</STRONG>to help the other members find it more quickly,&nbsp;don't forget to give a&nbsp;<STRONG>"Kudos"</STRONG>&nbsp;– I’d truly appreciate it!&nbsp;</SPAN></P> <P>&nbsp;</P> <P>Thanks and regards,</P> <P>Anjan Kumar Chippa</P> Wed, 28 May 2025 13:13:24 GMT v-achippa 2025-05-28T13:13:24Z Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4710187#M180387 <P>Hello Experts,</P><P>&nbsp;</P><P>Could you please support me? I can not solve it in PowerBi.</P><P>&nbsp;</P><P>I have a table with demands below. The columns are the months(with format date), de rows is the days when we needed to check the demands. We do not have rule for the dates of days, for example: every second day...etc., if we would like to see, we refresh it.</P><TABLE><TBODY><TR><TD>Days</TD><TD>2025.May</TD><TD>2025.June</TD><TD>2025.July</TD><TD>2025.August</TD><TD>2025.September</TD></TR><TR><TD>2025.05.28</TD><TD>5 000</TD><TD>5 000</TD><TD>10 000</TD><TD>13 000</TD><TD>15 000</TD></TR><TR><TD>2025.05.26</TD><TD>10 000</TD><TD>13 000</TD><TD>5 000</TD><TD>6 000</TD><TD>5 000</TD></TR><TR><TD>2025.05.23</TD><TD>15 000</TD><TD>6 000</TD><TD>15 000</TD><TD>7 000</TD><TD>13 000</TD></TR><TR><TD>2025.05.19</TD><TD>13 000</TD><TD>7 000</TD><TD>13 000</TD><TD>8 000</TD><TD>6 000</TD></TR><TR><TD>2025.05.18</TD><TD>6 000</TD><TD>8 000</TD><TD>6 000</TD><TD>4 000</TD><TD>7 000</TD></TR><TR><TD>2025.05.16</TD><TD>7 000</TD><TD>4 000</TD><TD>7 000</TD><TD>5 000</TD><TD>8 000</TD></TR><TR><TD>2025.05.10</TD><TD>8 000</TD><TD>5 000</TD><TD>8 000</TD><TD>15 000</TD><TD>4 000</TD></TR><TR><TD>2025.05.09</TD><TD>4 000</TD><TD>15 000</TD><TD>4 000</TD><TD>10 000</TD><TD>10 000</TD></TR></TBODY></TABLE><P>I would like to see in the cells only the changes between the two days in the new other table or matrix. What is it mean:&nbsp;</P><P><img /></P><P>&nbsp;</P><P>How can i solve it? I could not find any solution.</P><P>&nbsp;</P><P>Thank you in advance!</P><P>&nbsp;</P> Wed, 28 May 2025 11:41:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4710187#M180387 Someone22 2025-05-28T11:41:05Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4710467#M180396 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1282814" data-lia-user-login="Someone22" class="lia-mention lia-mention-user">Someone22</a>&nbsp;,</P> <P>&nbsp;</P> <P>To calculate the change in demand between consecutive days for each month in Power BI, you need to reshape your data first using Power Query. Start by unpivoting all the month columns (like 2025.May, 2025.June, etc.) so they become values in a single column instead of being separate headers. This transforms your table into a long format with columns for the Date, Month, and Demand.</P> <P>Once loaded into Power BI in this format, you can create a DAX measure that calculates the difference in demand between the current row and the previous date for the same month. Here's the DAX measure you can use:</P> <LI-CODE lang="markup">Demand Change = VAR CurrentDate = MAX('YourTable'[Date]) VAR CurrentMonth = SELECTEDVALUE('YourTable'[Month]) VAR CurrentDemand = MAX('YourTable'[Demand]) VAR PrevDate = CALCULATE( MAX('YourTable'[Date]), FILTER( ALL('YourTable'), 'YourTable'[Date] &lt; CurrentDate &amp;&amp; 'YourTable'[Month] = CurrentMonth ) ) VAR PrevDemand = CALCULATE( MAX('YourTable'[Demand]), 'YourTable'[Date] = PrevDate &amp;&amp; 'YourTable'[Month] = CurrentMonth ) RETURN IF(ISBLANK(PrevDemand), BLANK(), CurrentDemand - PrevDemand) </LI-CODE> <P>Replace 'YourTable' with the name of your actual table. This measure compares each date’s demand to the demand from the previous date for the same month and returns the difference. Then, place Date in the rows, Month in the columns, and this measure as the value in a Matrix visual. This will give you exactly what your Excel mock-up shows—highlighting daily changes across months. You can then apply conditional formatting to match your Excel color coding.</P> <P>&nbsp;</P> <P>Best regards,</P> Wed, 28 May 2025 12:43:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4710467#M180396 DataNinja777 2025-05-28T12:43:57Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4710511#M180397 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1282814" data-lia-user-login="Someone22" class="lia-mention lia-mention-user">Someone22</a>,</P> <P>&nbsp;</P> <P><SPAN>Thank you for reaching out to Microsoft Fabric Community.</SPAN></P> <P>&nbsp;</P> <P>Based on your description, please follow below steps:</P> <UL> <LI>Open Power Query Editor select all month columns (2025.May to 2025.September) and click Unpivot Columns.</LI> <LI>Sort the Days column in descending order.</LI> <LI>Go to Add Column --&gt; Index Column and add a custom index column from 0 and name it as Index.</LI> <LI>Duplicate the table and name it PreviousRow and rename its Index column to PreviousIndex.</LI> <LI>And merge the original table with PreviousRow, on Month = Month and on Index = PreviousIndex + 1.</LI> <LI>Expand the merged table and extract the previous demand value.</LI> <LI>After the merge create a new column to calculate the difference:<BR />= [Demand] - [PreviousRow.Demand]</LI> <LI>Click Close &amp; Apply and load the data back to power bi.</LI> <LI>Create a Matrix visual and use Days in Rows, Month in Columns and calculated difference in Values.</LI> </UL> <P>This matrix will now show the demand changes compared to the previous snapshot date for each month.</P> <P>&nbsp;</P> <P>If this post&nbsp;helps, then please consider<SPAN>&nbsp;<STRONG>Accepting as solution&nbsp;</STRONG>to help the other members find it more quickly,&nbsp;don't forget to give a&nbsp;<STRONG>"Kudos"</STRONG>&nbsp;– I’d truly appreciate it!&nbsp;</SPAN></P> <P>&nbsp;</P> <P>Thanks and regards,</P> <P>Anjan Kumar Chippa</P> Wed, 28 May 2025 13:13:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4710511#M180397 v-achippa 2025-05-28T13:13:24Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4711450#M180442 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="608865" data-lia-user-login="DataNinja777" class="lia-mention lia-mention-user">DataNinja777</a>&nbsp;,</P><P>I tried it, working, but it show wrong values. You see in below.</P><P><img /></P><P>&nbsp;</P><P>In the database there are other columns, not just Date, Months and Demand. It is cause maybe the problem? But the other columns are needed because of the filters.</P><P>&nbsp;</P><P>Thank you in advance again if you can check what would be the problem!</P> Thu, 29 May 2025 07:19:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4711450#M180442 Someone22 2025-05-29T07:19:34Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4711509#M180448 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="882907" data-lia-user-login="v-achippa" class="lia-mention lia-mention-user">v-achippa</a>&nbsp;,</P><P>I tried it, but the database is too big and the index step kill the query :(. I can not finish the step because the query freeze.</P> Thu, 29 May 2025 07:15:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4711509#M180448 Someone22 2025-05-29T07:15:48Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4712000#M180460 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1282814" data-lia-user-login="Someone22" class="lia-mention lia-mention-user">Someone22</a>,</P> <P>&nbsp;</P> <P>Thank you for the response, when working with large datasets the Index and Merge method can be slow or even freeze the power query. So please follow this below performance optimized approach:</P> <UL> <LI>Open Power Query Editor select all month columns (2025.May to 2025.September) and click Unpivot Columns. Rename columns to Days, Month, Demand.</LI> <LI>Make sure Days column is in date format, and sort by Month and then Days in descending order</LI> <LI>Duplicate the table and name it as PreviousRow.</LI> <LI>In the original table, rename the Days column to CurrentDay. And in the PreviousRow, rename the Days column to PreviousDay.</LI> <LI>Add a new custom column and name it as NextSnapshotDay and use the below code:<BR />= Date.AddDays([PreviousDay], 1)</LI> <LI>Now merge the original table with PreviousRow, on Month = Month and CurrentDay from original table = NextSnapshotDay from PreviousRow</LI> <LI>Expand the merged PreviousRow table and extract PreviousDay and Demand. Rename the extracted Demand column to PreviousDemand.</LI> <LI>After the merge add a new column to calculate the difference:<BR />= [Demand] - [PreviousDemand]</LI> <LI>Click Close &amp; Apply to load the transformed data.</LI> <LI>Create a Matrix visual and use CurrentDay in Rows, Month in Columns and calculated difference in Values.</LI> </UL> <P>This approach avoids heavy index operations and performs better on large datasets and It will show the change in demand between the current snapshot and the previous one for each month.</P> <P>&nbsp;</P> <P>If this post&nbsp;helps, then please consider<SPAN>&nbsp;<STRONG>Accepting as solution&nbsp;</STRONG>to help the other members find it more quickly,&nbsp;don't forget to give a&nbsp;<STRONG>"Kudos"</STRONG>&nbsp;– I’d truly appreciate it!&nbsp;</SPAN></P> <P>&nbsp;</P> <P>Thanks and regards,</P> <P>Anjan Kumar Chippa</P> Thu, 29 May 2025 10:39:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4712000#M180460 v-achippa 2025-05-29T10:39:52Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4713289#M180523 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="608865" data-lia-user-login="DataNinja777" class="lia-mention lia-mention-user">DataNinja777</a>&nbsp;,</P><P>I am new in PBI and i think i missed something really important. Sorry for that. The database in power query, it is not the same what i sent in my first post. The table in my first post is the summary table about raw table from query and i think this is the problem why the dax can not show what i want because in the same Day and Month rows there are more different demands.</P><P>&nbsp;</P><P>So, for an example review my raw database in power query after unpivot the months columns:</P><P>Raw database in power query:</P><TABLE><TBODY><TR><TD>Days</TD><TD>Material</TD><TD>Type</TD><TD>City</TD><TD>Months</TD><TD>Demand</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>500</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>700</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>300</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>500</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>600</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>900</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1100</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1500</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>400</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>700</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>320</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>675</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>456</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>234</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>953</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1134</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1054</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>454</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>245</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>1034</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>103</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>567</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>345</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>876</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1256</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2210</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>222</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>621</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>453</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>389</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>750</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>350</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>650</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>950</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1150</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1550</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>450</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>750</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>370</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>725</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>506</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>284</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>1003</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1184</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1104</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>504</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>295</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>1084</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>153</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>617</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>395</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>926</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1306</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2260</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>272</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>671</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>503</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>439</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>450</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>650</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>250</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>450</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>850</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1050</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1450</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>350</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>650</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>270</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>625</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>406</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>184</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>903</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1084</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1004</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>404</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>195</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>984</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>53</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>517</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>295</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>826</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1206</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2160</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>172</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>571</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>403</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>339</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>600</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>800</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>400</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>600</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>700</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>1000</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1200</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1600</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>500</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>800</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>420</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>775</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>556</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>334</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>1053</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1234</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1154</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>554</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>345</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>1134</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>203</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>667</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>445</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>976</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1356</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2310</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>322</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>721</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>553</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>489</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>350</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>150</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>350</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>450</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>750</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>950</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1350</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>250</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>550</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>170</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>525</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>306</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>84</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>803</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>984</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>904</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>304</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>95</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>884</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>47</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>417</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>195</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>726</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1106</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2060</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>72</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>471</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>303</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>239</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Summary and compare(what i want to see in PBI) matrix:</P><P><img /></P><P>&nbsp;</P><P>I am really sorry again :).</P><P>Thank you in advance!</P><P>&nbsp;</P> Fri, 30 May 2025 05:35:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4713289#M180523 Someone22 2025-05-30T05:35:17Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4713339#M180524 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="882907" data-lia-user-login="v-achippa" class="lia-mention lia-mention-user">v-achippa</a>&nbsp;,</P><P>Unfortunately it is not working, the query can not handle the merge :(. After 1 hour thinking the query freeze.</P><P>&nbsp;</P><P>Like i mentoned to DataNinja,</P><P>i think i missed something really important. Sorry for that. The database in power query, it is not the same what i sent in my first post. The table in my first post is the summary table about raw table from query and i think this is the problem why the dax can not show what i want because in the same Day and Month rows there are more different demands.</P><P>&nbsp;</P><P>So, for an example review my raw database in power query after unpivot the months columns:</P><P>Raw database in power query:</P><TABLE><TBODY><TR><TD>Days</TD><TD>Material</TD><TD>Type</TD><TD>City</TD><TD>Months</TD><TD>Demand</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>500</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>700</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>300</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>500</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>600</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>900</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1100</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1500</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>400</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>700</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>320</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>675</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>456</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>234</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>953</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1134</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1054</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>454</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>245</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>1034</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>103</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>567</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>345</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>876</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1256</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2210</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>222</TD></TR><TR><TD>2025.05.30</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>621</TD></TR><TR><TD>2025.05.30</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>453</TD></TR><TR><TD>2025.05.30</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>389</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>750</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>350</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>650</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>950</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1150</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1550</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>450</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>750</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>370</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>725</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>506</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>284</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>1003</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1184</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1104</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>504</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>295</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>1084</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>153</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>617</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>395</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>926</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1306</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2260</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>272</TD></TR><TR><TD>2025.05.28</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>671</TD></TR><TR><TD>2025.05.28</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>503</TD></TR><TR><TD>2025.05.28</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>439</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>450</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>650</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>250</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>450</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>850</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1050</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1450</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>350</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>650</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>270</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>625</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>406</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>184</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>903</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1084</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1004</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>404</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>195</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>984</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>53</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>517</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>295</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>826</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1206</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2160</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>172</TD></TR><TR><TD>2025.05.27</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>571</TD></TR><TR><TD>2025.05.27</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>403</TD></TR><TR><TD>2025.05.27</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>339</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>600</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>800</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>400</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>600</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>700</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>1000</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>1200</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1600</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>500</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>800</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>420</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>775</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>556</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>334</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>1053</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>1234</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>1154</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>554</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>345</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>1134</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>203</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>667</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>445</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>976</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1356</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2310</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>322</TD></TR><TR><TD>2025.05.15</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>721</TD></TR><TR><TD>2025.05.15</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>553</TD></TR><TR><TD>2025.05.15</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>489</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>350</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>550</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>150</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>350</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>450</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>750</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>950</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>1350</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>250</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>550</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>170</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>525</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>306</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>84</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>803</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>984</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>904</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>304</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>95</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>884</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>47</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>417</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>195</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>726</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>1106</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>2060</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>72</TD></TR><TR><TD>2025.05.05</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>471</TD></TR><TR><TD>2025.05.05</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>303</TD></TR><TR><TD>2025.05.05</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>239</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025. May</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.June</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.July</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.August</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>X</TD><TD>Big</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>X</TD><TD>Small</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>X</TD><TD>Medium</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>A</TD><TD>Y</TD><TD>Big</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>B</TD><TD>Y</TD><TD>Small</TD><TD>2025.September</TD><TD>0</TD></TR><TR><TD>2025.05.01</TD><TD>C</TD><TD>Y</TD><TD>Medium</TD><TD>2025.September</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><SPAN>Summary and compare(what i want to see in PBI) matrix:</SPAN></P><P><img /></P><P>&nbsp;</P><P>I am really sorry again :).</P><P>Thank you in advance!</P><P>&nbsp;</P> Fri, 30 May 2025 05:56:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4713339#M180524 Someone22 2025-05-30T05:56:39Z Re: Create Matrix or Table with compare data between dates in PowerBi https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4714025#M180557 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="608865" data-lia-user-login="DataNinja777" class="lia-mention lia-mention-user">DataNinja777</a>&nbsp;,</P><P>Based on your DAX, i start to thinking about the operation of it. After some hours i found the right changes and now it is working :D. I changed 2 MAX to SUM and it is perfect(<FONT color="#FF0000">RED highlight</FONT>).</P><P>&nbsp;</P><DIV><DIV><DIV><EM>Demand Change =</EM></DIV><DIV><EM>VAR CurrentDate = MAX('YourTable'[Date])</EM></DIV><DIV><EM>VAR CurrentMonth = SELECTEDVALUE('YourTable'[Month])</EM></DIV><DIV><EM>VAR CurrentDemand = <FONT color="#FF0000">SUM</FONT>('YourTable'[Demand])</EM></DIV><BR /><DIV><EM>VAR PrevDate =</EM></DIV><DIV><EM>&nbsp; &nbsp; CALCULATE(</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; MAX('YourTable'[Date]),</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; FILTER(</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL('YourTable'),</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'YourTable'[Date] &lt; CurrentDate &amp;&amp;</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'YourTable'[Month] = CurrentMonth</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; )</EM></DIV><DIV><EM>&nbsp; &nbsp; )</EM></DIV><BR /><DIV><EM>VAR PrevDemand =</EM></DIV><DIV><EM>&nbsp; &nbsp; CALCULATE(</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; <FONT color="#FF0000">SUM</FONT>('YourTable'[Demand]),</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; 'YourTable'[Date] = PrevDate &amp;&amp;</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; 'YourTable'[Month] = CurrentMonth</EM></DIV><DIV><EM>&nbsp; &nbsp; )</EM></DIV><BR /><DIV><EM>RETURN</EM></DIV><DIV><EM>&nbsp; &nbsp; IF(ISBLANK(PrevDemand), BLANK(), CurrentDemand - PrevDemand)</EM></DIV></DIV></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><P><STRONG>Thank you again for your support! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></STRONG></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 30 May 2025 11:27:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-Matrix-or-Table-with-compare-data-between-dates-in/m-p/4714025#M180557 Someone22 2025-05-30T11:27:12Z