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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
devgian
Frequent Visitor

FORMAT created column to MMM

Hello Everyone, 

I have a created column 

4/17/2023 4:19:06 AM

I created another column and i want this column created to be a month and i used 

Month = FORMAT(tbl[created], "MMM") but it did not change. 

Am i doing it incorrectly?

Thanks in advance for your help

1 ACCEPTED SOLUTION
devgian
Frequent Visitor

Got it. 

Month = FORMAT(DATEVALUE(tbl[created]), "MMM") 
//DATEVALUE SOLVES IT 

View solution in original post

1 REPLY 1
devgian
Frequent Visitor

Got it. 

Month = FORMAT(DATEVALUE(tbl[created]), "MMM") 
//DATEVALUE SOLVES IT 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.