topic Re: YTD measure for different months in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-measure-for-different-months/m-p/3451586#M131497 <P>Thank you very much! great help! how about MTD and QTD formula?</P> Thu, 28 Sep 2023 11:18:17 GMT FR14 2023-09-28T11:18:17Z YTD measure for different months https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-measure-for-different-months/m-p/3451109#M131465 <DIV><DIV><SPAN>Hi Everyone <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I am looking for a way to show YTD,MTD, for different months this yea and last year.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>These are my YTD and MTD formulas could you please let me know if they are correct? how can i modify them to show for previous year?</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>CY Bookings Annualized =</SPAN> <SPAN>Calculate</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>OrderLine</SPAN><SPAN>[Booking USD]</SPAN><SPAN>), </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>'OrderLine'</SPAN><SPAN>[Open_Date]</SPAN><SPAN>) = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>()), </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>'OrderLine'</SPAN><SPAN>[Open_Date]</SPAN><SPAN>) &lt;= </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>()))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><DIV><SPAN>CY MTD Bookings Annualized USD =</SPAN> <SPAN>Calculate</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>OrderLine</SPAN><SPAN>[Booking USD]</SPAN><SPAN>), </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>OrderLine</SPAN><SPAN>[Open_Date]</SPAN><SPAN>) = </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>()), </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>OrderLine</SPAN><SPAN>[Open_Date]</SPAN><SPAN>) = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>()))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you very much!</SPAN></DIV></DIV></DIV></DIV> Thu, 28 Sep 2023 06:42:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-measure-for-different-months/m-p/3451109#M131465 FR14 2023-09-28T06:42:16Z Re: YTD measure for different months https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-measure-for-different-months/m-p/3451229#M131473 <P>Modification for previous year</P><P><SPAN>CY Bookings Annualized = </SPAN></P><P><SPAN>CALCULATE ( </SPAN></P><P><SPAN>SUM ( OrderLine[Booking USD] ), </SPAN></P><P><SPAN>YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ), </SPAN></P><P><SPAN>MONTH ( 'OrderLine'[Open_Date] ) &lt;= MONTH ( TODAY() </SPAN></P><P><SPAN>) </SPAN></P><P><SPAN>)</SPAN></P><P>&nbsp;</P><P><SPAN>PY Bookings Annualized = </SPAN></P><P><SPAN>CALCULATE ( </SPAN></P><P><SPAN>SUM ( OrderLine[Booking USD] ), </SPAN></P><P><SPAN>YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ) - 1, -- Adjust for Previous Year </SPAN></P><P><SPAN>MONTH ( 'OrderLine'[Open_Date] ) &lt;= MONTH ( TODAY() </SPAN></P><P><SPAN>) </SPAN></P><P><SPAN>)</SPAN></P> Thu, 28 Sep 2023 07:38:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-measure-for-different-months/m-p/3451229#M131473 nirali_arora 2023-09-28T07:38:44Z Re: YTD measure for different months https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-measure-for-different-months/m-p/3451586#M131497 <P>Thank you very much! great help! how about MTD and QTD formula?</P> Thu, 28 Sep 2023 11:18:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-measure-for-different-months/m-p/3451586#M131497 FR14 2023-09-28T11:18:17Z