Month and Year (MMM-YYYY) from a date column

[Shahinkmajeed]

Dear All,

I am trying to create a new column with Month and Year in MMM-YYYY format from another date column. I tried the below expression for the new column, but getting the error as in the below screenshot. Kindly help.

MonthYr = CONCATENATE(FORMAT(MONTH(Query2[DEP_DATE]),"MMM"),YEAR(Query2[DEP_DATE]))

[Prakash-1993]

Will the column stay in date format or turns into text format.. I want to use it as monthyear slicer in my report.

[Shahinkmajeed]

For e.g I want the new column with the values like "AUG-2018". 

Looking forward for help. 

[Shahinkmajeed · Accepted solution]

Dear All,

I got the solution. Just used the format option in the Modeling tab 🙂

Sorry for the confusion.

Regards,