Solved: Month name to Month Numbers

raassd · ‎08-09-2022

Hi Team,

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

I dont have date column.

Thanks !

Jihwan_Kim · ‎08-09-2022

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 ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim · ‎08-09-2022

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 ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Riv · ‎07-27-2023

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

Month name to Month Numbers