topic Re: help needed with cumulative of a measure in Report Server https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720500#M40982 <P>Awesome, happy to hear it worked!</P> Thu, 05 Jun 2025 03:27:51 GMT SamsonTruong 2025-06-05T03:27:51Z help needed with cumulative of a measure https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720310#M40979 <P>Hi all,</P><P>We are using Power BI Report Server (May 2025 version). I would like to get cumulative/running sum of a measure by period.&nbsp;</P><P>Here is my sample test data:</P><P>Period table:</P><TABLE><TBODY><TR><TD>Period_integer</TD><TD>FY</TD><TD>Period</TD><TD>per_begin_date</TD><TD>per_end_date</TD></TR><TR><TD>202401</TD><TD>FY 2024</TD><TD>Jul-23</TD><TD>1/07/2023</TD><TD>31/07/2023</TD></TR><TR><TD>202402</TD><TD>FY 2024</TD><TD>Aug-23</TD><TD><P>1/0</P><P>8/2023</P></TD><TD>31/08/2023</TD></TR><TR><TD>202403</TD><TD>FY 2024</TD><TD>Sep-23</TD><TD>1/09/2023</TD><TD>30/09/2023</TD></TR><TR><TD>202404</TD><TD>FY 2024</TD><TD>Oct-23</TD><TD>1/10/2023</TD><TD>31/10/2023</TD></TR><TR><TD>202405</TD><TD>FY 2024</TD><TD>Nov-23</TD><TD>1/11/2023</TD><TD>30/11/2023</TD></TR><TR><TD>202406</TD><TD>FY 2024</TD><TD>Dec-23</TD><TD>1/12/2023</TD><TD>31/12/2023</TD></TR><TR><TD>202407</TD><TD>FY 2024</TD><TD>Jan-24</TD><TD>1/01/2024</TD><TD>31/01/2024</TD></TR><TR><TD>202408</TD><TD>FY 2024</TD><TD>Feb-24</TD><TD>1/02/2024</TD><TD>29/02/2024</TD></TR><TR><TD>202409</TD><TD>FY 2024</TD><TD>Mar-24</TD><TD>1/03/2024</TD><TD>31/03/2024</TD></TR><TR><TD>202410</TD><TD>FY 2024</TD><TD>Apr-24</TD><TD>1/04/2024</TD><TD>30/04/2024</TD></TR><TR><TD>202411</TD><TD>FY 2024</TD><TD>May-24</TD><TD>1/05/2024</TD><TD>31/05/2024</TD></TR><TR><TD>202412</TD><TD>FY 2024</TD><TD>Jun-24</TD><TD>1/06/2024</TD><TD>30/06/2024</TD></TR><TR><TD>202501</TD><TD>FY 2025</TD><TD>Jul-24</TD><TD>1/07/2024</TD><TD>31/07/2024</TD></TR><TR><TD>202502</TD><TD>FY 2025</TD><TD>Aug-24</TD><TD>1/08/2024</TD><TD>31/08/2024</TD></TR><TR><TD>202503</TD><TD>FY 2025</TD><TD>Sep-24</TD><TD>1/09/2024</TD><TD>30/09/2024</TD></TR><TR><TD>202504</TD><TD>FY 2025</TD><TD>Oct-24</TD><TD>1/10/2024</TD><TD>31/10/2024</TD></TR><TR><TD>202505</TD><TD>FY 2025</TD><TD>Nov-24</TD><TD>1/11/2024</TD><TD>30/11/2024</TD></TR><TR><TD>202506</TD><TD>FY 2025</TD><TD>Dec-24</TD><TD>1/12/2024</TD><TD>31/12/2024</TD></TR><TR><TD>202507</TD><TD>FY 2025</TD><TD>Jan-25</TD><TD>1/01/2025</TD><TD>31/01/2025</TD></TR><TR><TD>202508</TD><TD>FY 2025</TD><TD>Feb-25</TD><TD>1/02/2025</TD><TD>28/02/2025</TD></TR><TR><TD>202509</TD><TD>FY 2025</TD><TD>Mar-25</TD><TD>1/03/2025</TD><TD>31/03/2025</TD></TR><TR><TD>202510</TD><TD>FY 2025</TD><TD>Apr-25</TD><TD>1/04/2025</TD><TD>30/04/2025</TD></TR></TBODY></TABLE><P>FTE table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>period</TD><TD>FE code</TD><TD>FTE</TD></TR><TR><TD>202501</TD><TD>0001</TD><TD>200</TD></TR><TR><TD>202501</TD><TD>0002</TD><TD>220</TD></TR><TR><TD>202501</TD><TD>0003</TD><TD>180</TD></TR><TR><TD>202502</TD><TD>0001</TD><TD>170</TD></TR><TR><TD>202502</TD><TD>0002</TD><TD>230</TD></TR><TR><TD>202502</TD><TD>0003</TD><TD>220</TD></TR><TR><TD>202503</TD><TD>0001</TD><TD>190</TD></TR><TR><TD>202503</TD><TD>0002</TD><TD>210</TD></TR><TR><TD>202503</TD><TD>0003</TD><TD>210</TD></TR><TR><TD>202504</TD><TD>0001</TD><TD>210</TD></TR><TR><TD>202504</TD><TD>0002</TD><TD>220</TD></TR><TR><TD>202504</TD><TD>0003</TD><TD>160</TD></TR><TR><TD>202505</TD><TD>0001</TD><TD>150</TD></TR><TR><TD>202505</TD><TD>0002</TD><TD>250</TD></TR><TR><TD>202505</TD><TD>0003</TD><TD>135</TD></TR><TR><TD>202506</TD><TD>0001</TD><TD>175</TD></TR><TR><TD>202506</TD><TD>0002</TD><TD>215</TD></TR><TR><TD>202506</TD><TD>0003</TD><TD>195</TD></TR><TR><TD>202507</TD><TD>0001</TD><TD>220</TD></TR><TR><TD>202507</TD><TD>0002</TD><TD>215</TD></TR><TR><TD>202507</TD><TD>0003</TD><TD>200</TD></TR></TBODY></TABLE><P>Hours table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>period</TD><TD>FE code</TD><TD>Disc_Hrs</TD></TR><TR><TD>202501</TD><TD>0001</TD><TD>600</TD></TR><TR><TD>202501</TD><TD>0002</TD><TD>500</TD></TR><TR><TD>202501</TD><TD>0003</TD><TD>700</TD></TR><TR><TD>202502</TD><TD>0001</TD><TD>500</TD></TR><TR><TD>202502</TD><TD>0002</TD><TD>600</TD></TR><TR><TD>202502</TD><TD>0003</TD><TD>650</TD></TR><TR><TD>202503</TD><TD>0001</TD><TD>450</TD></TR><TR><TD>202503</TD><TD>0002</TD><TD>500</TD></TR><TR><TD>202503</TD><TD>0003</TD><TD>390</TD></TR><TR><TD>202504</TD><TD>0001</TD><TD>450</TD></TR><TR><TD>202504</TD><TD>0002</TD><TD>550</TD></TR><TR><TD>202504</TD><TD>0003</TD><TD>625</TD></TR><TR><TD>202505</TD><TD>0001</TD><TD>500</TD></TR><TR><TD>202505</TD><TD>0002</TD><TD>525</TD></TR><TR><TD>202505</TD><TD>0003</TD><TD>670</TD></TR><TR><TD>202506</TD><TD>0001</TD><TD>635</TD></TR><TR><TD>202506</TD><TD>0002</TD><TD>475</TD></TR><TR><TD>202506</TD><TD>0003</TD><TD>590</TD></TR><TR><TD>202507</TD><TD>0001</TD><TD>585</TD></TR><TR><TD>202507</TD><TD>0002</TD><TD>655</TD></TR><TR><TD>202507</TD><TD>0003</TD><TD>490</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have created a new measure as below:</P><DIV><DIV><SPAN>HoursperFTE =</SPAN> <SPAN>SUM</SPAN><SPAN>(Hours</SPAN><SPAN>[Disc_Hrs]</SPAN><SPAN>) / </SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>FTE</SPAN><SPAN>[FTE]</SPAN><SPAN> )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Now I would like to get the cumulative/running sum of the above measure HoursperFTE by period. </SPAN></DIV><DIV><SPAN>Can someone help with this?</SPAN></DIV><DIV><SPAN>Thanks,</SPAN></DIV><DIV><SPAN>grkanth81</SPAN></DIV></DIV> Wed, 04 Jun 2025 21:45:35 GMT https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720310#M40979 grkanth81 2025-06-04T21:45:35Z Re: help needed with cumulative of a measure https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720388#M40980 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="27720" data-lia-user-login="grkanth81" class="lia-mention lia-mention-user">grkanth81</a>&nbsp;,<BR /><BR />Can you try the following DAX measure&nbsp;<SPAN>to get the cumulative/running sum</SPAN> and let me know if it achieves your desired result:</P><LI-CODE lang="markup">Cumulative_HoursperFTE = VAR CurrentPeriod = SELECTEDVALUE(Period[Period_integer]) RETURN SUMX( FILTER( ALL(Period), Period[Period_integer] &lt;= CurrentPeriod ), CALCULATE( SUM(Hours[Disc_Hrs]) / SUM(FTE[FTE]) ) )</LI-CODE><P>&nbsp;</P><P><SPAN>If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.</SPAN><SPAN><BR /></SPAN><SPAN><BR /></SPAN><SPAN>Thanks,</SPAN></P><P><SPAN>Samson</SPAN></P><P>&nbsp;</P> Thu, 05 Jun 2025 00:33:51 GMT https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720388#M40980 SamsonTruong 2025-06-05T00:33:51Z Re: help needed with cumulative of a measure https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720437#M40981 <P>Thanks Samson. That worked perfectly.</P> Thu, 05 Jun 2025 01:58:32 GMT https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720437#M40981 grkanth81 2025-06-05T01:58:32Z Re: help needed with cumulative of a measure https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720500#M40982 <P>Awesome, happy to hear it worked!</P> Thu, 05 Jun 2025 03:27:51 GMT https://community.fabric.microsoft.com/t5/Report-Server/help-needed-with-cumulative-of-a-measure/m-p/4720500#M40982 SamsonTruong 2025-06-05T03:27:51Z