https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-a-Chart-with-the-correct-dates/m-p/849312#M6637 <P>I was able to fix this problem</P> Mon, 18 Nov 2019 18:51:18 GMT TiaCamilian 2019-11-18T18:51:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-a-Chart-with-the-correct-dates/m-p/836364#M6212 <P>My calculation to the 12 Month Rolling Average is:</P><DIV><DIV><SPAN>12 Month Rolling Average = </SPAN></DIV><DIV><SPAN>DIVIDE</SPAN></DIV><DIV><SPAN>(</SPAN></DIV><DIV><SPAN>QuoteConvertionStartDate[AcceptedRoll], </SPAN></DIV><DIV><SPAN>QuoteConvertionStartDate[TotalRoll]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>*100</SPAN></DIV><DIV><SPAN>Now I need to put the the "%Accepted" and "12 Month Rolling Average" in a chart,</SPAN></DIV><DIV><SPAN>I am getting empty "%Accepted" values and not empty on the "12 Month Rolling Average" values.</SPAN></DIV><DIV><SPAN>I need to only put the information until "Tuesday, December 1, 2020" but I don't know how to get the correct </SPAN></DIV><DIV><SPAN>"12 Month Rolling Average" information.</SPAN></DIV></DIV><P><img /></P><P>This is what I am getting:</P><P><img /></P><P>What can I do to eliminate the extra values from "12 Month"Rolling Average"?</P><P>This is what I need:</P><P>&nbsp;</P><P><img /></P><P>I was thinking of using an IF statement with Datebetween but is not working.</P><P>&nbsp;</P><P>Can someone please help me.</P> Mon, 04 Nov 2019 15:10:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-a-Chart-with-the-correct-dates/m-p/836364#M6212 TiaCamilian 2019-11-04T15:10:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-a-Chart-with-the-correct-dates/m-p/849312#M6637 <P>I was able to fix this problem</P> Mon, 18 Nov 2019 18:51:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-a-Chart-with-the-correct-dates/m-p/849312#M6637 TiaCamilian 2019-11-18T18:51:18Z