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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Converting Month Names in short text to Date

I have to identical tables with Column named month which has short text values of month names (Jan, Feb, Mar.....etc). I need to convert it to date. I am using below formula which works for one table but for other it throws an error. Can anyone please explain what I am doing wrong or any better alternatives.

 

Formula:  Month Seq = DATEVALUE(FORMAT( "1-" & FY20[Month] & "-" & FY20[Year], "dd-mmm-yy" ))

Error:

prafull2013_0-1643550826189.png

 

1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

Hi,

This error is likely caused by a row in your data where your month and year columns are blank. You can add this kind of IF clause to counter this: 

IF(OR(DateFromParts[Month]=BLANK(),DateFromParts[Year]=BLANK()),BLANK(),
DATEVALUE(FORMAT( "1-" & DateFromParts[Month] & "-" & dateFromParts[Year], "dd-mmm-yy" ))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ValtteriN
Super User
Super User

Hi,

This error is likely caused by a row in your data where your month and year columns are blank. You can add this kind of IF clause to counter this: 

IF(OR(DateFromParts[Month]=BLANK(),DateFromParts[Year]=BLANK()),BLANK(),
DATEVALUE(FORMAT( "1-" & DateFromParts[Month] & "-" & dateFromParts[Year], "dd-mmm-yy" ))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Thanks @ValtteriN . Yes there was a blank row! and your alternate formula worked like a charm.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.