Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Month name to Month Numbers

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 ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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 ) )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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's avatar
Riv
Advocate I
3 years ago

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