Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Shahinkmajeed
Helper I
Helper I

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

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]))

 

 

image.png

1 ACCEPTED SOLUTION

Dear All,

 

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

 

Sorry for the confusion.

 

 

Regards,

 

View solution in original post

3 REPLIES 3
Prakash-1993
Regular Visitor

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

Shahinkmajeed
Helper I
Helper I

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

 

Looking forward for help. 

 

Dear All,

 

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

 

Sorry for the confusion.

 

 

Regards,

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.