topic Re: How to make Line Chart stop mid-graph for future weeks in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2383174#M61660 <P>Hi,&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>'Final_data'[ISOWeekNum]= </SPAN><SPAN>if</SPAN><SPAN>(</SPAN><SPAN>and</SPAN><SPAN>(</SPAN><SPAN>Final_data[Received Week Number]</SPAN><SPAN>&gt;</SPAN><SPAN>51</SPAN><SPAN>,</SPAN><SPAN>month</SPAN><SPAN>(</SPAN><SPAN>Final_data[DateOfApplication]</SPAN><SPAN>)=</SPAN><SPAN>1</SPAN><SPAN>),</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>Final_data[Received Week Number]</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>to handle whenever week 52 or 53 ends in a new year.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I'have not linked the calendar table directedly to the main table, but I'm using the calendar as my date table.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I have suceeded in making the line chart stop mid graph implementing the following code</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><DIV><SPAN>CurrentY(Accumulated+PrevYear) = </SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'Calendar'[ISOWeekNum]</SPAN><SPAN>)&gt;=</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>Final_data[DateOfApplication]</SPAN><SPAN>),</SPAN><SPAN>2</SPAN><SPAN>),</SPAN><SPAN>Blank</SPAN><SPAN>(), </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>CurrentWeek_</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>MAX</SPAN><SPAN> ( </SPAN><SPAN>'Calendar'[ISOWeekNum]</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>StudyYear</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>AppYear</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>PrevAppYear</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN><SPAN>-</SPAN><SPAN>1</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>PrevYFinal</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>COUNTROWS</SPAN><SPAN> ( </SPAN><SPAN>'Final_data'</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>, </SPAN><SPAN>Final_data[Year of Studystart]</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN></DIV><DIV><SPAN>, </SPAN><SPAN>Final_data[Year of Application]</SPAN><SPAN> = </SPAN><SPAN>PrevAppYear</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Var</SPAN> <SPAN>AccumCY</SPAN><SPAN>=</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>COUNTROWS</SPAN><SPAN> ( </SPAN><SPAN>'Final_data'</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>'Final_data'[ISOWeekNum]</SPAN><SPAN> &lt;= </SPAN><SPAN>CurrentWeek_</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Final_data'[Year of Studystart]</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Final_data'[Year of Application]</SPAN><SPAN>=</SPAN><SPAN>AppYear</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Return</SPAN></DIV><DIV><SPAN>AccumCY</SPAN><SPAN>+</SPAN><SPAN>PrevYFinal</SPAN><SPAN>)</SPAN></DIV></DIV></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Wed, 09 Mar 2022 09:29:10 GMT Anonymous 2022-03-09T09:29:10Z How to make Line Chart stop mid-graph for future weeks https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2370617#M60820 <P>Hi,</P><P>&nbsp;</P><P>I've made a line chart, showcasing the accumultion of received applications throughout the weeks of 2022 compared to 2021.&nbsp;</P><P>&nbsp;</P><P>The dataline for 2022, do not have values/data for future weeks and I'd like the line for 2022 to stop mid-graph at the current weeknumber. But, I can't figure out how to.</P><P>&nbsp;</P><P>This is my current graph:</P><P><img /></P><P>&nbsp;</P><P>Measure for accumulatation current year</P><DIV><DIV><SPAN>CurrentY(Accumulated+PrevYear) = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>CurrentWeek_</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>MAX</SPAN><SPAN> ( </SPAN><SPAN>'Calendar'[ISOWeekNum]</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>StudyYear</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>AppYear</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>PrevAppYear</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN><SPAN>-</SPAN><SPAN>1</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>PrevYFinal</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>COUNTROWS</SPAN><SPAN> ( </SPAN><SPAN>'Final_data'</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>, </SPAN><SPAN>Final_data[Year of Studystart]</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN></DIV><DIV><SPAN>, </SPAN><SPAN>Final_data[Year of Application]</SPAN><SPAN> = </SPAN><SPAN>PrevAppYear</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Var</SPAN> <SPAN>AccumCY</SPAN><SPAN>=</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>COUNTROWS</SPAN><SPAN> ( </SPAN><SPAN>'Final_data'</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>'Final_data'[ISOWeekNum]</SPAN><SPAN> &lt;= </SPAN><SPAN>CurrentWeek_</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Final_data'[Year of Studystart]</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Final_data'[Year of Application]</SPAN><SPAN>=</SPAN><SPAN>AppYear</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Return</SPAN></DIV><DIV><SPAN>AccumCY</SPAN><SPAN>+</SPAN><SPAN>PrevYFinal</SPAN></DIV></DIV><P>&nbsp;</P><P>This is a data sample</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>DateOfApplication</TD><TD>Studystartdate</TD><TD>Received Week Number</TD><TD>Year of Application</TD><TD>Year of Studystart</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>&nbsp;</P><P>Thanks in advance <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P>&nbsp;</P> Wed, 02 Mar 2022 16:22:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2370617#M60820 Anonymous 2022-03-02T16:22:53Z Re: How to make Line Chart stop mid-graph for future weeks https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2370732#M60829 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>&nbsp;</P> <P>What you want to do is compare the current (or possibly last) week number available in the data to the week number in the axis - use MAX(WeekNumber).&nbsp; If the week number in the axis &gt; current/last available in data then BLANK() otherwise show value.</P> <P>&nbsp;</P> <P>Hope this helps!</P> Wed, 02 Mar 2022 17:23:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2370732#M60829 littlemojopuppy 2022-03-02T17:23:09Z Re: How to make Line Chart stop mid-graph for future weeks https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2383128#M61653 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P> <P>&nbsp;</P> <P>How does 'Final_data'[ISOWeekNum] come from?</P> <P>Does your calendar table have a relationship with the main table?<BR />Your image is not clear enough, I can't see the specific content in Fields.</P> <P>When publishing, you can enlarge the size of your image.</P> <P><img /></P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Stephen Tao</P> <P>&nbsp;</P> <P>If this post <STRONG>helps</STRONG>, then please consider<STRONG><EM> Accept it as the solution </EM></STRONG>to help the other members find it more quickly.</P> <P>&nbsp;</P> Wed, 09 Mar 2022 09:15:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2383128#M61653 Anonymous 2022-03-09T09:15:12Z Re: How to make Line Chart stop mid-graph for future weeks https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2383174#M61660 <P>Hi,&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>'Final_data'[ISOWeekNum]= </SPAN><SPAN>if</SPAN><SPAN>(</SPAN><SPAN>and</SPAN><SPAN>(</SPAN><SPAN>Final_data[Received Week Number]</SPAN><SPAN>&gt;</SPAN><SPAN>51</SPAN><SPAN>,</SPAN><SPAN>month</SPAN><SPAN>(</SPAN><SPAN>Final_data[DateOfApplication]</SPAN><SPAN>)=</SPAN><SPAN>1</SPAN><SPAN>),</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>Final_data[Received Week Number]</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>to handle whenever week 52 or 53 ends in a new year.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I'have not linked the calendar table directedly to the main table, but I'm using the calendar as my date table.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I have suceeded in making the line chart stop mid graph implementing the following code</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><DIV><SPAN>CurrentY(Accumulated+PrevYear) = </SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'Calendar'[ISOWeekNum]</SPAN><SPAN>)&gt;=</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>Final_data[DateOfApplication]</SPAN><SPAN>),</SPAN><SPAN>2</SPAN><SPAN>),</SPAN><SPAN>Blank</SPAN><SPAN>(), </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>CurrentWeek_</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>MAX</SPAN><SPAN> ( </SPAN><SPAN>'Calendar'[ISOWeekNum]</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>StudyYear</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>AppYear</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>PrevAppYear</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN><SPAN>-</SPAN><SPAN>1</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>PrevYFinal</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>COUNTROWS</SPAN><SPAN> ( </SPAN><SPAN>'Final_data'</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>, </SPAN><SPAN>Final_data[Year of Studystart]</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN></DIV><DIV><SPAN>, </SPAN><SPAN>Final_data[Year of Application]</SPAN><SPAN> = </SPAN><SPAN>PrevAppYear</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Var</SPAN> <SPAN>AccumCY</SPAN><SPAN>=</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>COUNTROWS</SPAN><SPAN> ( </SPAN><SPAN>'Final_data'</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>'Final_data'[ISOWeekNum]</SPAN><SPAN> &lt;= </SPAN><SPAN>CurrentWeek_</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Final_data'[Year of Studystart]</SPAN><SPAN> = </SPAN><SPAN>StudyYear</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Final_data'[Year of Application]</SPAN><SPAN>=</SPAN><SPAN>AppYear</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Return</SPAN></DIV><DIV><SPAN>AccumCY</SPAN><SPAN>+</SPAN><SPAN>PrevYFinal</SPAN><SPAN>)</SPAN></DIV></DIV></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Wed, 09 Mar 2022 09:29:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-Line-Chart-stop-mid-graph-for-future-weeks/m-p/2383174#M61660 Anonymous 2022-03-09T09:29:10Z