https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-in-Power-query/m-p/2712162#M82431 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="329393" data-lia-user-login="Nihed" class="lia-mention lia-mention-user">Nihed</a>&nbsp;,</P> <P>You can also refer the following links to get it by <STRONG>DAX</STRONG>:</P> <P><A href="https://databear.com/power-bi-tips-calculate-year-to-date-values/" target="_self">Power BI Tips: Calculate Year-to-date Values</A></P> <LI-CODE lang="markup">YTDSumOfSales = TOTALYTD([SumOfSales],’Calendar'[Date])</LI-CODE> <P><A href="https://www.phdata.io/blog/ytd-calculations-in-power-bi/" target="_self">How to Create YTD Calculations in Power BI​</A></P> <LI-CODE lang="markup">Sales YTD = TOTALYTD( SUM(Orders[Sales]), Orders[Order_Date], ALL(Orders) )</LI-CODE> <P>Best Regards</P> Fri, 19 Aug 2022 09:48:02 GMT Anonymous 2022-08-19T09:48:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-in-Power-query/m-p/2702914#M81875 <P>Hello,</P><P>&nbsp;</P><P>Please how I can calculate YTD in power query ,what is the syntax please (urgent)</P><P>Thank you</P> Tue, 16 Aug 2022 11:29:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-in-Power-query/m-p/2702914#M81875 Nihed 2022-08-16T11:29:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-in-Power-query/m-p/2703042#M81882 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="329393" data-lia-user-login="Nihed" class="lia-mention lia-mention-user">Nihed</a>&nbsp;</P> <P>&nbsp;</P> <P>Please check this one <A href="https://powerusers.microsoft.com/t5/Power-Query/YTD-sum-of-columns-in-Power-Query-based-on-input-from-Excel/td-p/1415495" target="_blank" rel="noopener">https://powerusers.microsoft.com/t5/Power-Query/YTD-sum-of-columns-in-Power-Query-based-on-input-from-Excel/td-p/1415495</A></P> <P>&nbsp;</P> <P>Thanks,</P> <P>Ritesh</P> <DIV id="bodyDisplay_3" class=""> <DIV class=""><STRONG><FONT color="#FF0000">Mark my post as a solution if it helped you|<FONT color="#000000">&nbsp;Munde and Kudis (Ladies and Gentlemen) I like your Kudos!!&nbsp;!!<BR /></FONT></FONT></STRONG> <P><FONT color="#000000"><STRONG><A href="https://www.youtube.com/channel/UCOK8xNgwlypFkU6aCEThCmw" target="_self" rel="nofollow noreferrer noopener">My YT Channel Dancing With Data&nbsp;!!&nbsp;</A><A href="https://www.linkedin.com/in/ritesh-bisht-22238913/" target="_self" rel="nofollow noreferrer noopener">Connect on Linkedin&nbsp;!!</A><A href="https://www.youtube.com/watch?v=XE-HehSTmGo&amp;list=PL9z26CJ-fucFCNaSAKlBujSFY22tZhcDr" target="_self" rel="nofollow noopener noreferrer">Power BI for Tableau Users&nbsp;</A></STRONG></FONT></P> </DIV> </DIV> Tue, 16 Aug 2022 12:11:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-in-Power-query/m-p/2703042#M81882 ribisht17 2022-08-16T12:11:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-in-Power-query/m-p/2712162#M82431 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="329393" data-lia-user-login="Nihed" class="lia-mention lia-mention-user">Nihed</a>&nbsp;,</P> <P>You can also refer the following links to get it by <STRONG>DAX</STRONG>:</P> <P><A href="https://databear.com/power-bi-tips-calculate-year-to-date-values/" target="_self">Power BI Tips: Calculate Year-to-date Values</A></P> <LI-CODE lang="markup">YTDSumOfSales = TOTALYTD([SumOfSales],’Calendar'[Date])</LI-CODE> <P><A href="https://www.phdata.io/blog/ytd-calculations-in-power-bi/" target="_self">How to Create YTD Calculations in Power BI​</A></P> <LI-CODE lang="markup">Sales YTD = TOTALYTD( SUM(Orders[Sales]), Orders[Order_Date], ALL(Orders) )</LI-CODE> <P>Best Regards</P> Fri, 19 Aug 2022 09:48:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-in-Power-query/m-p/2712162#M82431 Anonymous 2022-08-19T09:48:02Z