Month name to Month Numbers

[raassd]

Hi Team,

I have month names in m data I want to get month numbers.

I dont have date column.

Month	Required Results
Jan	01
Feb	02
Mar	03
Apr	04
May	05
Jun	06
July	07
Aug	08
Sep	09

Thanks !

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Required result CC =
MONTH ( CONVERT ( "2022-" & Data[Month] & "-01", DATETIME ) )

[Riv]

I tried this and I got this error: "Cannot convert value 'May' of type Text to type Date."