topic Re: Carry over previous year + accumulation current year in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2348579#M59495 <P>Hi&nbsp;Anonymous</LI-USER>, does this work?:</P><PRE>PreviousYearApplications = <BR />VAR StudyYear = MAX(Final_data[Year of StudyStart2])<BR />VAR PrevAppYear = MAX(Final_data[Year of Application2]) - 1<BR />RETURN<BR />CALCULATE(<BR />Final_data[NumberOfApplications]<BR />, ALL(Final_data)<BR />, Final_data[Year of StudyStart2] = StudyYear<BR />, Final_data[Year of Application2] = PrevAppYear<BR />)<BR /><BR />Accumulated + Previous Year = Final_data[AccumOfAplications2022] + [PreviousYearApplications]</PRE><P>EDIT: This may be better for when you have multiple years:</P><PRE>PreviousYearApplications = <BR />VAR StudyYear = MAX(Final_data[Year of StudyStart2])<BR />VAR AppYear = MAX(Final_data[Year of Application2])<BR />RETURN<BR />CALCULATE(<BR />Final_data[NumberOfApplications]<BR />, ALL(Final_data)<BR />, Final_data[Year of StudyStart2] = StudyYear<BR />, Final_data[Year of Application2] &lt; AppYear<BR />)</PRE><P>&nbsp;</P> Sat, 19 Feb 2022 00:53:26 GMT Russell-PBI 2022-02-19T00:53:26Z Carry over previous year + accumulation current year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2347930#M59438 <P>Hello,</P><P>&nbsp;</P><P>I'm having some trouble of how to add the carryover, of the number of received applications in the previous year with study start in 2022, to the accumulation of received application YTD with study start in 2022.&nbsp;</P><P>&nbsp;</P><P>At the moment I have succeeded in producing a graph for the accumulation across the whole timespan, but I can't seem to figure out how to add the number of application received in the previous year as a carry over from the previous year, such that my graph maps the [carryover]+[accumulation 2020] i.e. the carryover is the cutting of the y axis.&nbsp;</P><P>&nbsp;</P><P>This is my current graph</P><P><img /></P><P>Measure accumulation:</P><DIV><DIV><SPAN>AccumOfAplications2022 = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>Final_data</SPAN><SPAN>[NumberOfApplications]</SPAN><SPAN>,</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>Final_data[DateOfApplication]</SPAN><SPAN>),</SPAN><SPAN>Final_data[DateOfApplication]</SPAN><SPAN>&lt;=</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>Final_data[DateOfApplication]</SPAN><SPAN>)),</SPAN><SPAN>Final_data[Year of StudyStart2]</SPAN><SPAN>=</SPAN><SPAN>2022</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Measure Number of applications:</SPAN></DIV><DIV><DIV><DIV><SPAN>NumberOfApplications = </SPAN><SPAN>COUNTROWS</SPAN><SPAN>(</SPAN><SPAN>Final_data</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV>This is a data sample:</DIV><DIV>&nbsp;</DIV></DIV></DIV></DIV><TABLE><TBODY><TR><TD>DateOfApplication</TD><TD>Studystartdate</TD><TD>Received Week Number2</TD><TD>Year of Application2</TD><TD>Year of StudyStart2</TD></TR><TR><TD>05-02-2022</TD><TD>04-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>05-02-2022</TD><TD>04-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>05-02-2022</TD><TD>04-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>02-02-2022</TD><TD>04-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>31-01-2022</TD><TD>04-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>16-12-2021</TD><TD>31-07-2022</TD><TD>50</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>26-11-2021</TD><TD>10-01-2022</TD><TD>47</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>25-11-2021</TD><TD>10-01-2022</TD><TD>47</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>25-11-2021</TD><TD>10-01-2022</TD><TD>47</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>25-11-2021</TD><TD>10-01-2022</TD><TD>47</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>22-11-2021</TD><TD>31-07-2022</TD><TD>47</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>22-11-2021</TD><TD>10-01-2022</TD><TD>47</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>22-11-2021</TD><TD>10-01-2022</TD><TD>47</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>17-11-2021</TD><TD>10-01-2022</TD><TD>46</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>15-11-2021</TD><TD>10-01-2022</TD><TD>46</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>14-11-2021</TD><TD>10-01-2022</TD><TD>45</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>09-11-2021</TD><TD>10-01-2022</TD><TD>45</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>02-11-2021</TD><TD>10-01-2022</TD><TD>44</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>31-10-2021</TD><TD>10-01-2022</TD><TD>43</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>29-10-2021</TD><TD>10-01-2022</TD><TD>43</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>29-10-2021</TD><TD>10-01-2022</TD><TD>43</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>25-10-2021</TD><TD>10-01-2022</TD><TD>43</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>25-10-2021</TD><TD>10-01-2022</TD><TD>43</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>25-10-2021</TD><TD>10-01-2022</TD><TD>43</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>09-10-2021</TD><TD>10-01-2022</TD><TD>40</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>08-10-2021</TD><TD>10-01-2022</TD><TD>40</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>04-10-2021</TD><TD>10-01-2022</TD><TD>40</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>02-10-2021</TD><TD>10-01-2022</TD><TD>39</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>02-10-2021</TD><TD>10-01-2022</TD><TD>39</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>15-09-2021</TD><TD>31-07-2022</TD><TD>37</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>09-09-2021</TD><TD>10-01-2022</TD><TD>36</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>23-08-2021</TD><TD>10-01-2022</TD><TD>34</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>18-08-2021</TD><TD>10-01-2022</TD><TD>33</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>17-08-2021</TD><TD>10-01-2022</TD><TD>33</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>17-08-2021</TD><TD>10-01-2022</TD><TD>33</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>06-08-2021</TD><TD>31-07-2022</TD><TD>31</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>04-07-2021</TD><TD>10-01-2022</TD><TD>26</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>28-05-2021</TD><TD>10-01-2022</TD><TD>21</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>26-05-2021</TD><TD>10-01-2022</TD><TD>21</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>20-05-2021</TD><TD>10-01-2022</TD><TD>20</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>25-03-2021</TD><TD>10-01-2022</TD><TD>12</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>18-02-2021</TD><TD>31-07-2022</TD><TD>7</TD><TD>2021</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>04-08-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>04-08-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>30-03-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>08-08-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>04-02-2022</TD><TD>08-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>08-08-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>08-08-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>07-02-2022</TD><TD>08-08-2022</TD><TD>6</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>06-02-2022</TD><TD>30-03-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>06-02-2022</TD><TD>04-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>06-02-2022</TD><TD>30-03-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR><TR><TD>06-02-2022</TD><TD>04-08-2022</TD><TD>5</TD><TD>2022</TD><TD>2022</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance</P> Fri, 18 Feb 2022 15:05:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2347930#M59438 Anonymous 2022-02-18T15:05:18Z Re: Carry over previous year + accumulation current year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2348579#M59495 <P>Hi&nbsp;Anonymous</LI-USER>, does this work?:</P><PRE>PreviousYearApplications = <BR />VAR StudyYear = MAX(Final_data[Year of StudyStart2])<BR />VAR PrevAppYear = MAX(Final_data[Year of Application2]) - 1<BR />RETURN<BR />CALCULATE(<BR />Final_data[NumberOfApplications]<BR />, ALL(Final_data)<BR />, Final_data[Year of StudyStart2] = StudyYear<BR />, Final_data[Year of Application2] = PrevAppYear<BR />)<BR /><BR />Accumulated + Previous Year = Final_data[AccumOfAplications2022] + [PreviousYearApplications]</PRE><P>EDIT: This may be better for when you have multiple years:</P><PRE>PreviousYearApplications = <BR />VAR StudyYear = MAX(Final_data[Year of StudyStart2])<BR />VAR AppYear = MAX(Final_data[Year of Application2])<BR />RETURN<BR />CALCULATE(<BR />Final_data[NumberOfApplications]<BR />, ALL(Final_data)<BR />, Final_data[Year of StudyStart2] = StudyYear<BR />, Final_data[Year of Application2] &lt; AppYear<BR />)</PRE><P>&nbsp;</P> Sat, 19 Feb 2022 00:53:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2348579#M59495 Russell-PBI 2022-02-19T00:53:26Z Re: Carry over previous year + accumulation current year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2351264#M59692 <P>Hi, no it returns the following graph</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 21 Feb 2022 13:44:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2351264#M59692 Anonymous 2022-02-21T13:44:15Z Re: Carry over previous year + accumulation current year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2351293#M59696 <P>Well, that's wacky looking. Maybe put the various columns in a table and see what's happening with the individual sums against DateOfApplication. It worked when I tested it with your sample data, so maybe there's something else going on. The sudden ups and downs on the graph suggest it's adding the previous application count for some days but not others.</P> Mon, 21 Feb 2022 13:59:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2351293#M59696 Russell-PBI 2022-02-21T13:59:52Z Re: Carry over previous year + accumulation current year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2355504#M59956 <P>Thanks alot for the tip, of using a table, to detect what's&nbsp; happening with the sums!</P><P>I have finally succeeded in producing the graph, with carry over from the previous year.</P><P><img /></P><P>&nbsp;</P> Wed, 23 Feb 2022 09:32:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Carry-over-previous-year-accumulation-current-year/m-p/2355504#M59956 Anonymous 2022-02-23T09:32:11Z