datevalue from text to number

hi pardeepd84 

Try this measure:

Convert to date = DATEVALUE("01/"&FIRSTNONBLANK('Table'[Month Name],"")&"/2019")

the output will be as below:

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

Appreciate your Kudos  !!

Hi pardeepd84 ,

Based on my test, you could use the following formula to create a Date column or a Month number column:

Date= DATEVALUE("01-"&[Month Name]&"-2019")

Month Number = MONTH( DATEVALUE("01-"&[Month Name]&"-2019") )

 And then change the Format as you expect:

Refer to:

DATEVALUE function (DAX) - DAX | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.