topic Re: Running Total Help in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071651#M161641 <P>It's still not working. Here's the data:</P><TABLE border="1"><TBODY><TR><TD>Year-Week</TD><TD>wc</TD><TD>Demand</TD><TD>AvgHoursPW</TD><TD>Demand-HoursPW</TD><TD>RunningTotalDemand-HrsPWHrs</TD><TD>WeeklyTriggerHrs</TD><TD>TotalHrsCurrent</TD><TD>TotalHrsPastDue</TD><TD>Sum of run_mch_hrs_per_day</TD></TR><TR><TD>2023-24</TD><TD>CELL A</TD><TD>0.16</TD><TD>14.85874</TD><TD>-14.6987</TD><TD>0</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>0.16</TD><TD>2.476457</TD></TR><TR><TD>2024-01</TD><TD>CELL A</TD><TD>17.29821</TD><TD>14.85874</TD><TD>2.439471</TD><TD>-14.6987</TD><TD>16.45821</TD><TD>0.84</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-20</TD><TD>CELL A</TD><TD>0.72</TD><TD>14.85874</TD><TD>-14.1387</TD><TD>-28.8375</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>0.72</TD><TD>2.476457</TD></TR><TR><TD>2024-21</TD><TD>CELL A</TD><TD>1.48</TD><TD>14.85874</TD><TD>-13.3787</TD><TD>-42.2162</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>1.48</TD><TD>2.476457</TD></TR><TR><TD>2024-22</TD><TD>CELL A</TD><TD>7.68</TD><TD>14.85874</TD><TD>-7.17874</TD><TD>-68.3937</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>7.68</TD><TD>2.476457</TD></TR><TR><TD>2024-23</TD><TD>CELL A</TD><TD>6.96</TD><TD>14.85874</TD><TD>-7.89874</TD><TD>-92.2312</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>6.96</TD><TD>2.476457</TD></TR><TR><TD>2024-24</TD><TD>CELL A</TD><TD>25.33</TD><TD>14.85874</TD><TD>10.47126</TD><TD>-128.737</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>25.33</TD><TD>2.476457</TD></TR><TR><TD>2024-25</TD><TD>CELL A</TD><TD>36.6</TD><TD>14.85874</TD><TD>21.74126</TD><TD>-179.022</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>36.6</TD><TD>2.476457</TD></TR><TR><TD>2024-26</TD><TD>CELL A</TD><TD>5.7</TD><TD>14.85874</TD><TD>-9.15874</TD><TD>-237.107</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>5.7</TD><TD>2.476457</TD></TR><TR><TD>2024-27</TD><TD>CELL A</TD><TD>119.25</TD><TD>14.85874</TD><TD>104.3913</TD><TD>-235.744</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>119.25</TD><TD>2.476457</TD></TR><TR><TD>2024-28</TD><TD>CELL A</TD><TD>697.2</TD><TD>14.85874</TD><TD>682.3413</TD><TD>-145.257</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>697.2</TD><TD>2.476457</TD></TR><TR><TD>2024-29</TD><TD>CELL A</TD><TD>466.86</TD><TD>14.85874</TD><TD>452.0013</TD><TD>-100.271</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>466.86</TD><TD>2.476457</TD></TR><TR><TD>2024-30</TD><TD>CELL A</TD><TD>349.3</TD><TD>14.85874</TD><TD>334.4413</TD><TD>-54.3347</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>349.3</TD><TD>2.476457</TD></TR><TR><TD>2024-31</TD><TD>CELL A</TD><TD>3476.808</TD><TD>14.85874</TD><TD>3461.949</TD><TD>0</TD><TD>16.45821</TD><TD>1780.55</TD><TD>1679.8</TD><TD>2.476457</TD></TR><TR><TD>2024-32</TD><TD>CELL A</TD><TD>5114.928</TD><TD>14.85874</TD><TD>5100.069</TD><TD>0</TD><TD>16.45821</TD><TD>5098.47</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-33</TD><TD>CELL A</TD><TD>9450.058</TD><TD>14.85874</TD><TD>9435.199</TD><TD>0</TD><TD>16.45821</TD><TD>9433.6</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-34</TD><TD>CELL A</TD><TD>7518.218</TD><TD>14.85874</TD><TD>7503.359</TD><TD>0</TD><TD>16.45821</TD><TD>7501.76</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-35</TD><TD>CELL A</TD><TD>17233.76</TD><TD>14.85874</TD><TD>17218.9</TD><TD>0</TD><TD>16.45821</TD><TD>17217.3</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-36</TD><TD>CELL A</TD><TD>5676.538</TD><TD>14.85874</TD><TD>5661.679</TD><TD>0</TD><TD>16.45821</TD><TD>5660.08</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-37</TD><TD>CELL A</TD><TD>4802.778</TD><TD>14.85874</TD><TD>4787.919</TD><TD>0</TD><TD>16.45821</TD><TD>4786.32</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-38</TD><TD>CELL A</TD><TD>46648.5</TD><TD>14.85874</TD><TD>46633.64</TD><TD>0</TD><TD>16.45821</TD><TD>46632.04</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-39</TD><TD>CELL A</TD><TD>22730.06</TD><TD>14.85874</TD><TD>22715.2</TD><TD>0</TD><TD>16.45821</TD><TD>22713.6</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-40</TD><TD>CELL A</TD><TD>4930.058</TD><TD>14.85874</TD><TD>4915.199</TD><TD>0</TD><TD>16.45821</TD><TD>4913.6</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-41</TD><TD>CELL A</TD><TD>7827.078</TD><TD>14.85874</TD><TD>7812.219</TD><TD>0</TD><TD>16.45821</TD><TD>7810.62</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR></TBODY></TABLE> Wed, 31 Jul 2024 15:03:13 GMT MichelleRoberts 2024-07-31T15:03:13Z Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071404#M161619 <P>Hello!</P><P>I have a data set that looks like this:</P><P><img /></P><P>Where</P><P class="lia-indent-padding-left-30px">Demand = WeeklyTriggerHrs + TotalHoursCurrent + TotalHrsPastDue</P><P class="lia-indent-padding-left-30px">AvgHoursPW = (Sum of run_mch_hrs_per_day)*6</P><P class="lia-indent-padding-left-30px">Demand-HoursPW = Demand - AvgHoursPW</P><P>&nbsp;</P><P>I'm having trouble with the RunningTotalDemand-HrsPWHrs. As you can see, it's not creating a running total. Here's the formula I've got so far:</P><DIV><DIV><SPAN>RunningTotalDemand-HrsPWHrs = </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; [Demand-HoursPW],</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ALL</SPAN><SPAN>('Calendar'),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar'[Date] &lt;= </SPAN><SPAN>MAX</SPAN><SPAN>('Calendar'[Date])</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can someone see where my error is? I also don't want it to add anything if there is no demand and the date is in the past, but I do want it to add if there is no demand and the date is current.</SPAN></DIV></DIV><P>&nbsp;</P> Wed, 31 Jul 2024 13:28:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071404#M161619 MichelleRoberts 2024-07-31T13:28:09Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071550#M161624 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558002" data-lia-user-login="MichelleRoberts" class="lia-mention lia-mention-user">MichelleRoberts</a>&nbsp;Hi!</P><P>Try with:<BR /><BR />RunningTotalDemand-HrsPWHrs =<BR />VAR CurrentDate = MAX('Calendar'[Date])<BR />RETURN<BR />CALCULATE(<BR />SUMX(<BR />FILTER(<BR />ALL('Calendar'),<BR />'Calendar'[Date] &lt;= CurrentDate<BR />),<BR />IF(<BR />[Demand] &gt; 0 || 'Calendar'[Date] = CurrentDate,<BR />[Demand-HoursPW],<BR />0<BR />)<BR />)<BR />)<BR /><BR /></P><P>If it's ok please accept my answer as solution, instead, paste me some sample data plis</P><P>&nbsp;</P><P>BBF</P> Wed, 31 Jul 2024 14:24:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071550#M161624 BeaBF 2024-07-31T14:24:17Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071574#M161629 <P>It's still not calculating correctly. I exported the data to Excel so I could calculate it and compare the two. See below.</P><P><img /></P> Wed, 31 Jul 2024 14:32:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071574#M161629 MichelleRoberts 2024-07-31T14:32:26Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071578#M161631 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558002" data-lia-user-login="MichelleRoberts" class="lia-mention lia-mention-user">MichelleRoberts</a>&nbsp;adjusted:</P><P>&nbsp;</P><P>RunningTotalDemand-HrsPWHrs =<BR />VAR CurrentDate = MAX('Calendar'[Date])<BR />RETURN<BR />CALCULATE(<BR />SUMX(<BR />FILTER(<BR />ALL('Calendar'),<BR />'Calendar'[Date] &lt;= CurrentDate<BR />),<BR />IF(<BR />[Demand] &gt; 0 || 'Calendar'[Date] = CurrentDate,<BR />[Demand-HoursPW],<BR />0<BR />)<BR />),<BR />ALLEXCEPT('Calendar', 'Calendar'[Date])<BR />)</P><P>&nbsp;</P><P>BBF</P> Wed, 31 Jul 2024 14:36:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071578#M161631 BeaBF 2024-07-31T14:36:34Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071627#M161636 <P>I now get this as a result:</P><P><img /></P> Wed, 31 Jul 2024 14:50:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071627#M161636 MichelleRoberts 2024-07-31T14:50:37Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071635#M161638 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558002" data-lia-user-login="MichelleRoberts" class="lia-mention lia-mention-user">MichelleRoberts</a>&nbsp;can you paste the data? so that i can do copy paste into a power bi and do some tests.&nbsp;</P><P>&nbsp;</P><P>meanwhile try with:</P><P>&nbsp;</P><P>RunningTotalDemand-HrsPWHrs =<BR />VAR CurrentDate = MAX('Calendar'[Date])<BR />RETURN<BR />CALCULATE(<BR />SUMX(<BR />FILTER(<BR />ALL('Calendar'),<BR />'Calendar'[Date] &lt;= CurrentDate<BR />),<BR />IF(<BR />[Demand] &gt; 0 || 'Calendar'[Date] = CurrentDate,<BR />[Demand-HoursPW],<BR />BLANK() -- Use BLANK() instead of 0 to avoid adding zero values<BR />)<BR />)<BR />)</P><P>&nbsp;</P><P>BBF</P> Wed, 31 Jul 2024 14:55:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071635#M161638 BeaBF 2024-07-31T14:55:11Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071651#M161641 <P>It's still not working. Here's the data:</P><TABLE border="1"><TBODY><TR><TD>Year-Week</TD><TD>wc</TD><TD>Demand</TD><TD>AvgHoursPW</TD><TD>Demand-HoursPW</TD><TD>RunningTotalDemand-HrsPWHrs</TD><TD>WeeklyTriggerHrs</TD><TD>TotalHrsCurrent</TD><TD>TotalHrsPastDue</TD><TD>Sum of run_mch_hrs_per_day</TD></TR><TR><TD>2023-24</TD><TD>CELL A</TD><TD>0.16</TD><TD>14.85874</TD><TD>-14.6987</TD><TD>0</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>0.16</TD><TD>2.476457</TD></TR><TR><TD>2024-01</TD><TD>CELL A</TD><TD>17.29821</TD><TD>14.85874</TD><TD>2.439471</TD><TD>-14.6987</TD><TD>16.45821</TD><TD>0.84</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-20</TD><TD>CELL A</TD><TD>0.72</TD><TD>14.85874</TD><TD>-14.1387</TD><TD>-28.8375</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>0.72</TD><TD>2.476457</TD></TR><TR><TD>2024-21</TD><TD>CELL A</TD><TD>1.48</TD><TD>14.85874</TD><TD>-13.3787</TD><TD>-42.2162</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>1.48</TD><TD>2.476457</TD></TR><TR><TD>2024-22</TD><TD>CELL A</TD><TD>7.68</TD><TD>14.85874</TD><TD>-7.17874</TD><TD>-68.3937</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>7.68</TD><TD>2.476457</TD></TR><TR><TD>2024-23</TD><TD>CELL A</TD><TD>6.96</TD><TD>14.85874</TD><TD>-7.89874</TD><TD>-92.2312</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>6.96</TD><TD>2.476457</TD></TR><TR><TD>2024-24</TD><TD>CELL A</TD><TD>25.33</TD><TD>14.85874</TD><TD>10.47126</TD><TD>-128.737</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>25.33</TD><TD>2.476457</TD></TR><TR><TD>2024-25</TD><TD>CELL A</TD><TD>36.6</TD><TD>14.85874</TD><TD>21.74126</TD><TD>-179.022</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>36.6</TD><TD>2.476457</TD></TR><TR><TD>2024-26</TD><TD>CELL A</TD><TD>5.7</TD><TD>14.85874</TD><TD>-9.15874</TD><TD>-237.107</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>5.7</TD><TD>2.476457</TD></TR><TR><TD>2024-27</TD><TD>CELL A</TD><TD>119.25</TD><TD>14.85874</TD><TD>104.3913</TD><TD>-235.744</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>119.25</TD><TD>2.476457</TD></TR><TR><TD>2024-28</TD><TD>CELL A</TD><TD>697.2</TD><TD>14.85874</TD><TD>682.3413</TD><TD>-145.257</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>697.2</TD><TD>2.476457</TD></TR><TR><TD>2024-29</TD><TD>CELL A</TD><TD>466.86</TD><TD>14.85874</TD><TD>452.0013</TD><TD>-100.271</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>466.86</TD><TD>2.476457</TD></TR><TR><TD>2024-30</TD><TD>CELL A</TD><TD>349.3</TD><TD>14.85874</TD><TD>334.4413</TD><TD>-54.3347</TD><TD>16.45821</TD><TD>&nbsp;</TD><TD>349.3</TD><TD>2.476457</TD></TR><TR><TD>2024-31</TD><TD>CELL A</TD><TD>3476.808</TD><TD>14.85874</TD><TD>3461.949</TD><TD>0</TD><TD>16.45821</TD><TD>1780.55</TD><TD>1679.8</TD><TD>2.476457</TD></TR><TR><TD>2024-32</TD><TD>CELL A</TD><TD>5114.928</TD><TD>14.85874</TD><TD>5100.069</TD><TD>0</TD><TD>16.45821</TD><TD>5098.47</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-33</TD><TD>CELL A</TD><TD>9450.058</TD><TD>14.85874</TD><TD>9435.199</TD><TD>0</TD><TD>16.45821</TD><TD>9433.6</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-34</TD><TD>CELL A</TD><TD>7518.218</TD><TD>14.85874</TD><TD>7503.359</TD><TD>0</TD><TD>16.45821</TD><TD>7501.76</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-35</TD><TD>CELL A</TD><TD>17233.76</TD><TD>14.85874</TD><TD>17218.9</TD><TD>0</TD><TD>16.45821</TD><TD>17217.3</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-36</TD><TD>CELL A</TD><TD>5676.538</TD><TD>14.85874</TD><TD>5661.679</TD><TD>0</TD><TD>16.45821</TD><TD>5660.08</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-37</TD><TD>CELL A</TD><TD>4802.778</TD><TD>14.85874</TD><TD>4787.919</TD><TD>0</TD><TD>16.45821</TD><TD>4786.32</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-38</TD><TD>CELL A</TD><TD>46648.5</TD><TD>14.85874</TD><TD>46633.64</TD><TD>0</TD><TD>16.45821</TD><TD>46632.04</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-39</TD><TD>CELL A</TD><TD>22730.06</TD><TD>14.85874</TD><TD>22715.2</TD><TD>0</TD><TD>16.45821</TD><TD>22713.6</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-40</TD><TD>CELL A</TD><TD>4930.058</TD><TD>14.85874</TD><TD>4915.199</TD><TD>0</TD><TD>16.45821</TD><TD>4913.6</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR><TR><TD>2024-41</TD><TD>CELL A</TD><TD>7827.078</TD><TD>14.85874</TD><TD>7812.219</TD><TD>0</TD><TD>16.45821</TD><TD>7810.62</TD><TD>&nbsp;</TD><TD>2.476457</TD></TR></TBODY></TABLE> Wed, 31 Jul 2024 15:03:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071651#M161641 MichelleRoberts 2024-07-31T15:03:13Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071693#M161644 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558002" data-lia-user-login="MichelleRoberts" class="lia-mention lia-mention-user">MichelleRoberts</a>&nbsp; based on this data, this formula works for me:</P><P>&nbsp;</P><DIV><DIV><SPAN>CumulativeDemandHoursPW = </SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN> CurrentYearWeek = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>('Table'[Year-Week])</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SUM</SPAN><SPAN>('Table'[Demand-HoursPW]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ALL</SPAN><SPAN>('Table'),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; 'Table'[Year-Week] &lt;= CurrentYearWeek</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P><P>&nbsp;</P><P>BBF</P></DIV></DIV> Wed, 31 Jul 2024 15:18:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071693#M161644 BeaBF 2024-07-31T15:18:26Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071796#M161649 <P>I see that it works for you but it's still not working for me. I'm going to try something else.</P><P>&nbsp;</P><P><img /></P> Wed, 31 Jul 2024 16:07:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071796#M161649 MichelleRoberts 2024-07-31T16:07:59Z Re: Running Total Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071802#M161651 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558002" data-lia-user-login="MichelleRoberts" class="lia-mention lia-mention-user">MichelleRoberts</a>&nbsp;can you upload the pbix in drive and share the link? so that i can work on your version.</P><P>&nbsp;</P><P>BBF</P> Wed, 31 Jul 2024 16:11:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-Help/m-p/4071802#M161651 BeaBF 2024-07-31T16:11:23Z