https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/query-on-date-format/m-p/4107160#M162984 <P>My period column is in "January 1, 2024" format and I want to convert it to "Jan 2024". It worked using format(period, "MMM yyyy") ONLY in text format. But I need it in Date format. The default text format doesn't contain this format.</P> Mon, 19 Aug 2024 14:54:45 GMT logan_logan 2024-08-19T14:54:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/query-on-date-format/m-p/4107160#M162984 <P>My period column is in "January 1, 2024" format and I want to convert it to "Jan 2024". It worked using format(period, "MMM yyyy") ONLY in text format. But I need it in Date format. The default text format doesn't contain this format.</P> Mon, 19 Aug 2024 14:54:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/query-on-date-format/m-p/4107160#M162984 logan_logan 2024-08-19T14:54:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/query-on-date-format/m-p/4107199#M162987 <P>Hi,</P> <P><SPAN>Select your date column or convert it to date column by changing data type&nbsp; and directly enter simple letters formating string as shown below</SPAN></P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 19 Aug 2024 15:26:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/query-on-date-format/m-p/4107199#M162987 Kaviraj11 2024-08-19T15:26:28Z