topic Re: cumulative sum in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum/m-p/3692426#M143512 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="688361" data-lia-user-login="corrado69" class="lia-mention lia-mention-user">corrado69</a>&nbsp;,</P><P>&nbsp;</P><P>Can you try the following formula?</P><LI-CODE lang="markup">CumulativeSum = CALCULATE([SumOfAandB],FILTER(ALL(Date), DateTable[Date] &lt;= MAX(DateTable[Date]))</LI-CODE> Sat, 10 Feb 2024 18:22:23 GMT govindarajan_d 2024-02-10T18:22:23Z cumulative sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum/m-p/3692354#M143509 <P>this is a simplified version of my project:</P><P>- una table with a column date and a colum A:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Date</TD><TD>A</TD></TR><TR><TD>01-gen</TD><TD>1</TD></TR><TR><TD>01-feb</TD><TD>2</TD></TR><TR><TD>01-mar</TD><TD>3</TD></TR><TR><TD>01-apr</TD><TD>4</TD></TR><TR><TD>01-mag</TD><TD>5</TD></TR><TR><TD>01-giu</TD><TD>6</TD></TR><TR><TD>01-lug</TD><TD>7</TD></TR><TR><TD>01-ago</TD><TD>8</TD></TR><TR><TD>01-set</TD><TD>9</TD></TR><TR><TD>01-ott</TD><TD>10</TD></TR><TR><TD>01-nov</TD><TD>11</TD></TR><TR><TD>01-dic</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>- una table with a column date and a colum B (with empty values in some rows):</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Date</TD><TD>B</TD></TR><TR><TD>01-gen</TD><TD>1</TD></TR><TR><TD>01-feb</TD><TD>2</TD></TR><TR><TD>01-mar</TD><TD>3</TD></TR><TR><TD>01-apr</TD><TD>&nbsp;</TD></TR><TR><TD>01-mag</TD><TD>&nbsp;</TD></TR><TR><TD>01-giu</TD><TD>&nbsp;</TD></TR><TR><TD>01-lug</TD><TD>&nbsp;</TD></TR><TR><TD>01-ago</TD><TD>&nbsp;</TD></TR><TR><TD>01-set</TD><TD>&nbsp;</TD></TR><TR><TD>01-ott</TD><TD>&nbsp;</TD></TR><TR><TD>01-nov</TD><TD>&nbsp;</TD></TR><TR><TD>01-dic</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>- a table with dates (I created a link with the date column of the other 2 tables):</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Data</TD></TR><TR><TD>01-gen</TD></TR><TR><TD>01-feb</TD></TR><TR><TD>01-mar</TD></TR><TR><TD>01-apr</TD></TR><TR><TD>01-mag</TD></TR><TR><TD>01-giu</TD></TR><TR><TD>01-lug</TD></TR><TR><TD>01-ago</TD></TR><TR><TD>01-set</TD></TR><TR><TD>01-ott</TD></TR><TR><TD>01-nov</TD></TR><TR><TD>01-dic</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to create a measure that is the cumulative sum of A+B for each month:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Data</TD><TD>A</TD><TD>B</TD><TD>A+B</TD><TD>cumul A+B</TD></TR><TR><TD>01-gen</TD><TD>1</TD><TD>1</TD><TD>2</TD><TD>2</TD></TR><TR><TD>01-feb</TD><TD>2</TD><TD>2</TD><TD>4</TD><TD>6</TD></TR><TR><TD>01-mar</TD><TD>3</TD><TD>3</TD><TD>6</TD><TD>12</TD></TR><TR><TD>01-apr</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD><TD>16</TD></TR><TR><TD>01-mag</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD><TD>21</TD></TR><TR><TD>01-giu</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD><TD>27</TD></TR><TR><TD>01-lug</TD><TD>7</TD><TD>&nbsp;</TD><TD>7</TD><TD>34</TD></TR><TR><TD>01-ago</TD><TD>8</TD><TD>&nbsp;</TD><TD>8</TD><TD>42</TD></TR><TR><TD>01-set</TD><TD>9</TD><TD>&nbsp;</TD><TD>9</TD><TD>51</TD></TR><TR><TD>01-ott</TD><TD>10</TD><TD>&nbsp;</TD><TD>10</TD><TD>61</TD></TR><TR><TD>01-nov</TD><TD>11</TD><TD>&nbsp;</TD><TD>11</TD><TD>72</TD></TR><TR><TD>01-dic</TD><TD>12</TD><TD>&nbsp;</TD><TD>12</TD><TD>84</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I'm able to calculate the cumulative sum if there are values in all rows of A and B but not if there are some empty values in one of the 2 columns A or B. In this case my formula gives a correct value from Jan to March but then gives values equal to A (if B is the column with empty values) from April to December.</P><P>&nbsp;</P> Sat, 10 Feb 2024 14:57:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum/m-p/3692354#M143509 corrado69 2024-02-10T14:57:37Z Re: cumulative sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum/m-p/3692426#M143512 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="688361" data-lia-user-login="corrado69" class="lia-mention lia-mention-user">corrado69</a>&nbsp;,</P><P>&nbsp;</P><P>Can you try the following formula?</P><LI-CODE lang="markup">CumulativeSum = CALCULATE([SumOfAandB],FILTER(ALL(Date), DateTable[Date] &lt;= MAX(DateTable[Date]))</LI-CODE> Sat, 10 Feb 2024 18:22:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum/m-p/3692426#M143512 govindarajan_d 2024-02-10T18:22:23Z