https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-create-a-new-column-displaying-QTD-and-NOT-QTD/m-p/961499#M11241 <P>I want to create a new column to display QTD and NOT QTD. I used the below measures to display 'YTD/NOT' and 'MTD/NOT'.</P><P>How can I display&nbsp;QTD and NOT QTD based on current date?</P><P>&nbsp;</P><DIV><UL><LI><SPAN>YTD/NOT = if('Date'[Invoice Month]&lt;MONTH(TODAY()),"YTD",IF(AND('Date'[Invoice Month]=MONTH(TODAY()),'Date'[Day]&lt;day(TODAY())),"YTD","NOT YTD"))</SPAN></LI></UL><DIV><DIV><UL><LI><SPAN>MTD/NOT = IF(AND('Date'[Invoice Month]=MONTH(TODAY()),'Date'[Day]&lt;day(TODAY())),"MTD","NOT MTD")</SPAN></LI></UL></DIV></DIV></DIV><P>&nbsp;</P><P><img /></P> Fri, 06 Mar 2020 05:29:58 GMT JihyeHeo 2020-03-06T05:29:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-create-a-new-column-displaying-QTD-and-NOT-QTD/m-p/961499#M11241 <P>I want to create a new column to display QTD and NOT QTD. I used the below measures to display 'YTD/NOT' and 'MTD/NOT'.</P><P>How can I display&nbsp;QTD and NOT QTD based on current date?</P><P>&nbsp;</P><DIV><UL><LI><SPAN>YTD/NOT = if('Date'[Invoice Month]&lt;MONTH(TODAY()),"YTD",IF(AND('Date'[Invoice Month]=MONTH(TODAY()),'Date'[Day]&lt;day(TODAY())),"YTD","NOT YTD"))</SPAN></LI></UL><DIV><DIV><UL><LI><SPAN>MTD/NOT = IF(AND('Date'[Invoice Month]=MONTH(TODAY()),'Date'[Day]&lt;day(TODAY())),"MTD","NOT MTD")</SPAN></LI></UL></DIV></DIV></DIV><P>&nbsp;</P><P><img /></P> Fri, 06 Mar 2020 05:29:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-create-a-new-column-displaying-QTD-and-NOT-QTD/m-p/961499#M11241 JihyeHeo 2020-03-06T05:29:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-create-a-new-column-displaying-QTD-and-NOT-QTD/m-p/961513#M11243 <P>Perhaps the new QUARTER function?</P> Fri, 06 Mar 2020 05:39:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-create-a-new-column-displaying-QTD-and-NOT-QTD/m-p/961513#M11243 Greg_Deckler 2020-03-06T05:39:19Z