https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-Date-calculation-for-Financial-Year-July1st2019-June30th/m-p/830850#M5997 <P>Hi,</P><P>&nbsp;</P><P>I would like to calculate Year to date for Financial Year((July1st2019-June30th 2020)</P><P>&nbsp;</P><P>How can I modify my dax measure accordingly.</P><P>&nbsp;</P><P>&nbsp;</P><P>Please advise.</P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Chiru</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 29 Oct 2019 05:53:36 GMT chiru5262 2019-10-29T05:53:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-Date-calculation-for-Financial-Year-July1st2019-June30th/m-p/830850#M5997 <P>Hi,</P><P>&nbsp;</P><P>I would like to calculate Year to date for Financial Year((July1st2019-June30th 2020)</P><P>&nbsp;</P><P>How can I modify my dax measure accordingly.</P><P>&nbsp;</P><P>&nbsp;</P><P>Please advise.</P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Chiru</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 29 Oct 2019 05:53:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-Date-calculation-for-Financial-Year-July1st2019-June30th/m-p/830850#M5997 chiru5262 2019-10-29T05:53:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-Date-calculation-for-Financial-Year-July1st2019-June30th/m-p/833373#M6073 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="182067" data-lia-user-login="chiru5262" class="lia-mention lia-mention-user">chiru5262</a>,</P><P>&nbsp;</P><P>Hope this link helps u</P><P>&nbsp;</P><P><A href="https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/" target="_blank">https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/</A>&nbsp;</P><P>&nbsp;</P><P>Regards<BR />Sac</P> Thu, 31 Oct 2019 05:08:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-Date-calculation-for-Financial-Year-July1st2019-June30th/m-p/833373#M6073 Anonymous 2019-10-31T05:08:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-Date-calculation-for-Financial-Year-July1st2019-June30th/m-p/833927#M6096 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="182067" data-lia-user-login="chiru5262" class="lia-mention lia-mention-user">chiru5262</a>&nbsp;,</P><P>in your case I recommend to use TOTALYTD:</P><P>&nbsp;</P><P>TOTALYTD(SUM(Amount) , 'Date'[Date], "6/30")</P><P>&nbsp;</P><P>Details see:&nbsp;<A href="https://docs.microsoft.com/en-us/dax/totalytd-function-dax" target="_blank">https://docs.microsoft.com/en-us/dax/totalytd-function-dax</A></P><P>&nbsp;</P><P>BR,</P><P>Thomas</P> Thu, 31 Oct 2019 12:55:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-Date-calculation-for-Financial-Year-July1st2019-June30th/m-p/833927#M6096 ThomasFuchs 2019-10-31T12:55:06Z