cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shahinkmajeed Regular Visitor
Regular Visitor

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

Accepted Solutions
Shahinkmajeed Regular Visitor
Regular Visitor

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

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

2 REPLIES 2
Shahinkmajeed Regular Visitor
Regular Visitor

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

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

 

Looking forward for help. 

 

Shahinkmajeed Regular Visitor
Regular Visitor

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

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

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 476 members 4,436 guests
Please welcome our newest community members: