topic Total for Next Three Months by Item Forecast in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-for-Next-Three-Months-by-Item-Forecast/m-p/3955985#M153552 <P>I need to write a measure that calculates total forecast&nbsp; (pallet quantity) for the next three months by item. For example item 10176NCM for the next three months May through July is 7.88 pallets and I need to have a measure calculate this. I would also like to see a total for the year. Below is my data set.</P><P>Thanks for your help</P><TABLE border="1"><TBODY><TR><TD>SoldTo</TD><TD>Item</TD><TD>Date</TD><TD>Forecast Pallets</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>12/1/2024</TD><TD>1.25</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>12/1/2024</TD><TD>1.54</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>12/1/2024</TD><TD>0.83</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>12/1/2024</TD><TD>0.05</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>12/1/2024</TD><TD>0</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>11/1/2024</TD><TD>0.82</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>11/1/2024</TD><TD>1.54</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>11/1/2024</TD><TD>0.18</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>11/1/2024</TD><TD>1.25</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>11/1/2024</TD><TD>0</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>10/1/2024</TD><TD>0.2</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>10/1/2024</TD><TD>0.34</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>10/1/2024</TD><TD>0</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>9/1/2024</TD><TD>0.66</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>9/1/2024</TD><TD>0.68</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>9/1/2024</TD><TD>1.1</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>8/1/2024</TD><TD>0.28</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>8/1/2024</TD><TD>0.95</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>8/1/2024</TD><TD>0.35</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>8/1/2024</TD><TD>0.47</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>7/1/2024</TD><TD>0</TD></TR><TR><TD>999999</TD><TD>10081NCM</TD><TD>7/1/2024</TD><TD>0.17</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>7/1/2024</TD><TD>0.83</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>7/1/2024</TD><TD>0.3</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>6/1/2024</TD><TD>0.27</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>6/1/2024</TD><TD>0</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>6/1/2024</TD><TD>2.43</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>6/1/2024</TD><TD>0.64</TD></TR><TR><TD>999999</TD><TD>10081NCM</TD><TD>6/1/2024</TD><TD>0.16</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>6/1/2024</TD><TD>0.79</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>5/1/2024</TD><TD>2.05</TD></TR><TR><TD>999999</TD><TD>10081NCM</TD><TD>5/1/2024</TD><TD>0.14</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>5/1/2024</TD><TD>0.34</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>5/1/2024</TD><TD>0.05</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>5/1/2024</TD><TD>1.61</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>5/1/2024</TD><TD>0</TD></TR></TBODY></TABLE> Tue, 28 May 2024 21:41:35 GMT GMadd 2024-05-28T21:41:35Z Total for Next Three Months by Item Forecast https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-for-Next-Three-Months-by-Item-Forecast/m-p/3955985#M153552 <P>I need to write a measure that calculates total forecast&nbsp; (pallet quantity) for the next three months by item. For example item 10176NCM for the next three months May through July is 7.88 pallets and I need to have a measure calculate this. I would also like to see a total for the year. Below is my data set.</P><P>Thanks for your help</P><TABLE border="1"><TBODY><TR><TD>SoldTo</TD><TD>Item</TD><TD>Date</TD><TD>Forecast Pallets</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>12/1/2024</TD><TD>1.25</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>12/1/2024</TD><TD>1.54</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>12/1/2024</TD><TD>0.83</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>12/1/2024</TD><TD>0.05</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>12/1/2024</TD><TD>0</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>11/1/2024</TD><TD>0.82</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>11/1/2024</TD><TD>1.54</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>11/1/2024</TD><TD>0.18</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>11/1/2024</TD><TD>1.25</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>11/1/2024</TD><TD>0</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>10/1/2024</TD><TD>0.2</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>10/1/2024</TD><TD>0.34</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>10/1/2024</TD><TD>0</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>9/1/2024</TD><TD>0.66</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>9/1/2024</TD><TD>0.68</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>9/1/2024</TD><TD>1.1</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>8/1/2024</TD><TD>0.28</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>8/1/2024</TD><TD>0.95</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>8/1/2024</TD><TD>0.35</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>8/1/2024</TD><TD>0.47</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>7/1/2024</TD><TD>0</TD></TR><TR><TD>999999</TD><TD>10081NCM</TD><TD>7/1/2024</TD><TD>0.17</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>7/1/2024</TD><TD>0.83</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>7/1/2024</TD><TD>0.3</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>6/1/2024</TD><TD>0.27</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>6/1/2024</TD><TD>0</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>6/1/2024</TD><TD>2.43</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>6/1/2024</TD><TD>0.64</TD></TR><TR><TD>999999</TD><TD>10081NCM</TD><TD>6/1/2024</TD><TD>0.16</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>6/1/2024</TD><TD>0.79</TD></TR><TR><TD>999999</TD><TD>10176NCM</TD><TD>5/1/2024</TD><TD>2.05</TD></TR><TR><TD>999999</TD><TD>10081NCM</TD><TD>5/1/2024</TD><TD>0.14</TD></TR><TR><TD>108695</TD><TD>10081NCM</TD><TD>5/1/2024</TD><TD>0.34</TD></TR><TR><TD>122488</TD><TD>10176NCM</TD><TD>5/1/2024</TD><TD>0.05</TD></TR><TR><TD>108695</TD><TD>10176NCM</TD><TD>5/1/2024</TD><TD>1.61</TD></TR><TR><TD>122488</TD><TD>10081NCM</TD><TD>5/1/2024</TD><TD>0</TD></TR></TBODY></TABLE> Tue, 28 May 2024 21:41:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-for-Next-Three-Months-by-Item-Forecast/m-p/3955985#M153552 GMadd 2024-05-28T21:41:35Z Re: Total for Next Three Months by Item Forecast https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-for-Next-Three-Months-by-Item-Forecast/m-p/3956315#M153561 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="663206" data-lia-user-login="GMadd" class="lia-mention lia-mention-user">GMadd</a>&nbsp;,</P> <P>&nbsp;</P> <P>Please create two measures:</P> <LI-CODE lang="markup">Total Forecast Next 3 Months = CALCULATE( SUM('Table'[Forecast Pallets]), DATESBETWEEN( 'Table'[Date], STARTOFMONTH('Table'[Date]), DATEADD(STARTOFMONTH('Table'[Date]), 2, MONTH) ), ALLEXCEPT('Table','Table'[Item]) ) Total Pallets = CALCULATE( SUM('Table'[Forecast Pallets]), ALL('Table') )</LI-CODE> <P>&nbsp;</P> <P>The visual effect of the page is as follows:</P> <P><img /></P> <P>&nbsp;</P> <P>The pbix file is attached.</P> <P>&nbsp;</P> <P>If you have any other questions, please feel free to contact me.</P> <P>&nbsp;</P> <P>Best Regards,<BR />Yang<BR />Community Support Team</P> <P>&nbsp;</P> <P>If there is any post&nbsp;<STRONG><EM>helps</EM></STRONG>, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG>&nbsp;&nbsp;to help the other members find it more quickly.<BR />If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;<STRONG><EM>Thanks a lot!</EM></STRONG></P> Wed, 29 May 2024 02:37:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-for-Next-Three-Months-by-Item-Forecast/m-p/3956315#M153561 Anonymous 2024-05-29T02:37:08Z