Dax- Get month number only from Month

[Anonymous]

Hello World, 
I have a column with just month. No date . I want create a new column "Month Number". 
How do I create it? 

[ValtteriN · Accepted solution]

Hi,

I assume you have the month in a format like "January"? You can create a mapping table and use that or create a dax like this:

Column = SWITCH('Table (17)'[Column1],

"January",1,

"February",2,
"March",3
//... continue this logic
"December",12
)

Example:

[Anonymous]

@ValtteriN Thank you very much Sir.