topic How to display current month's MTD for Year 2022 and Year2023, and hide the MTD for future date? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-display-current-month-s-MTD-for-Year-2022-and-Year2023/m-p/3120959#M156746 <P><SPAN>I want to remove the month slicer, how to display current month's MTD by month_day？e.g.: Today is March 9, I want to display the MTD of Year 2022 (from Mar 01 to Mar 31), also display </SPAN><SPAN>MTD of Year 2023 (from Mar 01 till today Mar 09, hide the MTD for future date).</SPAN></P><P>&nbsp;</P><P><SPAN>1. I have test data for orders, order_date have relationship with calendar Date Table.</SPAN></P><P><img /></P><P>2. Add a column for DateTable:&nbsp;&nbsp;</P><DIV><DIV><SPAN>BigthanLastOrderDate = </SPAN><SPAN>'DateTable'</SPAN><SPAN>[Date]</SPAN><SPAN> &lt;= </SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>testdata</SPAN><SPAN>[Order_date]</SPAN><SPAN>)</SPAN></DIV><DIV><img /></DIV><DIV>3. Add a measure for testdata table:</DIV><DIV><DIV><DIV><SPAN>Current_History_MTD = </SPAN><SPAN>TOTALMTD</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>('testdata'[total_amount_usd_without_tax]),'DateTable'[Date],'DateTable'[BigthanLastOrderDate]=True)</SPAN></DIV></DIV></DIV><DIV><img /><P>4.&nbsp; Create report with Month slicer and line chat as below:</P></DIV></DIV><P>&nbsp;</P><P><SPAN><img /></SPAN></P><P>&nbsp;</P> Thu, 09 Mar 2023 09:01:02 GMT tangcy123 2023-03-09T09:01:02Z How to display current month's MTD for Year 2022 and Year2023, and hide the MTD for future date? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-display-current-month-s-MTD-for-Year-2022-and-Year2023/m-p/3120959#M156746 <P><SPAN>I want to remove the month slicer, how to display current month's MTD by month_day？e.g.: Today is March 9, I want to display the MTD of Year 2022 (from Mar 01 to Mar 31), also display </SPAN><SPAN>MTD of Year 2023 (from Mar 01 till today Mar 09, hide the MTD for future date).</SPAN></P><P>&nbsp;</P><P><SPAN>1. I have test data for orders, order_date have relationship with calendar Date Table.</SPAN></P><P><img /></P><P>2. Add a column for DateTable:&nbsp;&nbsp;</P><DIV><DIV><SPAN>BigthanLastOrderDate = </SPAN><SPAN>'DateTable'</SPAN><SPAN>[Date]</SPAN><SPAN> &lt;= </SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>testdata</SPAN><SPAN>[Order_date]</SPAN><SPAN>)</SPAN></DIV><DIV><img /></DIV><DIV>3. Add a measure for testdata table:</DIV><DIV><DIV><DIV><SPAN>Current_History_MTD = </SPAN><SPAN>TOTALMTD</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>('testdata'[total_amount_usd_without_tax]),'DateTable'[Date],'DateTable'[BigthanLastOrderDate]=True)</SPAN></DIV></DIV></DIV><DIV><img /><P>4.&nbsp; Create report with Month slicer and line chat as below:</P></DIV></DIV><P>&nbsp;</P><P><SPAN><img /></SPAN></P><P>&nbsp;</P> Thu, 09 Mar 2023 09:01:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-display-current-month-s-MTD-for-Year-2022-and-Year2023/m-p/3120959#M156746 tangcy123 2023-03-09T09:01:02Z