topic Re: Cumulative sum measure in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4035891#M159938 <P><FONT>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="478342" data-lia-user-login="JC2022" class="lia-mention lia-mention-user">JC2022</a></FONT>&nbsp;</P> <P>&nbsp;</P> <P style="margin: 0in; background: white;"><SPAN>In order to better solve your problem, please open a new case, we recommend a case to solve only one problem, because this can get with good help, and also to give other users a better reference!</SPAN></P> <P style="margin: 0in; background: white;"><SPAN>&nbsp;</SPAN></P> <P style="margin: 0in; background: white;"><SPAN>Best Regards,</SPAN></P> <P>Jayleny</P> Thu, 11 Jul 2024 02:30:45 GMT Anonymous 2024-07-11T02:30:45Z Cumulative sum measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4032055#M159478 <P>Hi,</P><P>I have some trouble with creating a measure. I have the fields below from 2 tables. Date and MonthYear from a calendar table. The other columns are from a different table with obviously a relationship between Date columns.</P><P>Now I am trying to create a cumulative sum measure of the "Hours to do per workday". But this measure should be able to filter on a speficic Category and Team. But when removing a (for example) Team filter it should cumulate the sum per Category. And when removing the Category and Team it should cumulate the sum per Date. Etc.</P><P>Is anyone able to help me?&nbsp;</P><P>&nbsp;</P><P>Current fields:</P><TABLE><TBODY><TR><TD>Date</TD><TD>MonthYear</TD><TD>Category</TD><TD>Team</TD><TD>Project</TD><TD>Hours to do per workday</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category A</TD><TD>Team A</TD><TD>GH761008</TD><TD>0,90</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category B</TD><TD>Team I</TD><TD>AT511552</TD><TD>0,80</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category B</TD><TD>Team D</TD><TD>GH760640</TD><TD>0,85</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team C</TD><TD>AT510847</TD><TD>0,76</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team B</TD><TD>AT511637</TD><TD>0,97</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team E</TD><TD>GH760243</TD><TD>0,90</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team H</TD><TD>GH760556</TD><TD>0,80</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team F</TD><TD>GH760619</TD><TD>0,84</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team E</TD><TD>GH760809</TD><TD>0,86</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team G</TD><TD>GH760854</TD><TD>0,80</TD></TR><TR><TD>8-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team B</TD><TD>GH760885</TD><TD>0,78</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category A</TD><TD>Team A</TD><TD>GH761008</TD><TD>0,90</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category B</TD><TD>Team I</TD><TD>AT511552</TD><TD>0,80</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category B</TD><TD>Team D</TD><TD>GH760640</TD><TD>0,85</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team C</TD><TD>AT510847</TD><TD>0,76</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team B</TD><TD>AT511637</TD><TD>0,97</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team E</TD><TD>GH760243</TD><TD>0,90</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team H</TD><TD>GH760556</TD><TD>0,80</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team F</TD><TD>GH760619</TD><TD>0,84</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team E</TD><TD>GH760809</TD><TD>0,86</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team G</TD><TD>GH760854</TD><TD>0,80</TD></TR><TR><TD>9-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team B</TD><TD>GH760885</TD><TD>0,78</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category A</TD><TD>Team A</TD><TD>GH761008</TD><TD>0,90</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category B</TD><TD>Team I</TD><TD>AT511552</TD><TD>0,80</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category B</TD><TD>Team D</TD><TD>GH760640</TD><TD>0,85</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team C</TD><TD>AT510847</TD><TD>0,76</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team B</TD><TD>AT511637</TD><TD>0,97</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team E</TD><TD>GH760243</TD><TD>0,90</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team H</TD><TD>GH760556</TD><TD>0,80</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team F</TD><TD>GH760619</TD><TD>0,84</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team E</TD><TD>GH760809</TD><TD>0,86</TD></TR><TR><TD>10-7-2024</TD><TD>jul-24</TD><TD>Category C</TD><TD>Team G</TD><TD>GH760854</TD><TD>0,80</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Desired end result:</P><P><img /></P> Tue, 09 Jul 2024 08:17:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4032055#M159478 JC2022 2024-07-09T08:17:23Z Re: Cumulative sum measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4033370#M159668 <P><FONT>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="478342" data-lia-user-login="JC2022" class="lia-mention lia-mention-user">JC2022</a></FONT>&nbsp;</P> <P>&nbsp;</P> <P>All you need to do is put the corresponding fields into the matrix.</P> <P><img /></P> <P>&nbsp;</P> <P><BR />Result:</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Jayleny</P> <P>&nbsp;</P> <P>If this post&nbsp;<STRONG><EM>helps</EM></STRONG>, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG>&nbsp;to help the other members find it more quickly.</P> Wed, 10 Jul 2024 01:37:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4033370#M159668 Anonymous 2024-07-10T01:37:37Z Re: Cumulative sum measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4034760#M159854 <P>OK, yes this works.&nbsp;</P><P>But now I would like to see the cumulative sum over time. So on the 09/07/2024 date it should be the sum of&nbsp;08/07/2024 and&nbsp;09/07/2024 together. For the Categories, Teams and Projects. How can this be done in a measure?</P> Wed, 10 Jul 2024 13:36:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4034760#M159854 JC2022 2024-07-10T13:36:56Z Re: Cumulative sum measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4035891#M159938 <P><FONT>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="478342" data-lia-user-login="JC2022" class="lia-mention lia-mention-user">JC2022</a></FONT>&nbsp;</P> <P>&nbsp;</P> <P style="margin: 0in; background: white;"><SPAN>In order to better solve your problem, please open a new case, we recommend a case to solve only one problem, because this can get with good help, and also to give other users a better reference!</SPAN></P> <P style="margin: 0in; background: white;"><SPAN>&nbsp;</SPAN></P> <P style="margin: 0in; background: white;"><SPAN>Best Regards,</SPAN></P> <P>Jayleny</P> Thu, 11 Jul 2024 02:30:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-measure/m-p/4035891#M159938 Anonymous 2024-07-11T02:30:45Z