https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-and-running-Totals/m-p/3498199#M134046 <DIV><DIV><SPAN>YTD Sum RT =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Liters]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN> &lt;= </SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN>) = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>i wrote the dax above in hopes that i would get a running total on my line graph and it worked, but now i would like to show on the same line graph, a line for each year rather than all years as one line. i am struggling to figure out how i can apply, for example, only 2019 dates into this dax. what i have tried so far isnt working, and chat gpt also cant figure this out it seems. any help would be greatly appreciated.&nbsp;</SPAN></DIV></DIV> Thu, 26 Oct 2023 07:45:31 GMT Dominic91 2023-10-26T07:45:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-and-running-Totals/m-p/3498199#M134046 <DIV><DIV><SPAN>YTD Sum RT =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Liters]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN> &lt;= </SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN>) = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'TotalSale+LIS'</SPAN><SPAN>[Date]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>i wrote the dax above in hopes that i would get a running total on my line graph and it worked, but now i would like to show on the same line graph, a line for each year rather than all years as one line. i am struggling to figure out how i can apply, for example, only 2019 dates into this dax. what i have tried so far isnt working, and chat gpt also cant figure this out it seems. any help would be greatly appreciated.&nbsp;</SPAN></DIV></DIV> Thu, 26 Oct 2023 07:45:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-and-running-Totals/m-p/3498199#M134046 Dominic91 2023-10-26T07:45:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-and-running-Totals/m-p/3498213#M134047 <P>you need a year dimension in the visual legend.</P> Thu, 26 Oct 2023 07:53:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-and-running-Totals/m-p/3498213#M134047 wdx223_Daniel 2023-10-26T07:53:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-and-running-Totals/m-p/3498221#M134049 <P>Great, that worked. thanks for the help!!</P> Thu, 26 Oct 2023 07:58:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-and-running-Totals/m-p/3498221#M134049 Dominic91 2023-10-26T07:58:28Z