topic Re: Dax- Get month number only from Month in DAX Commands and Tips

Dax- Get month number only from Month

Anonymous — Fri, 09 Dec 2022 15:25:35 GMT

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 — Fri, 09 Dec 2022 15:54:45 GMT

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 — Fri, 09 Dec 2022 16:14:07 GMT

ValtteriN Thank you very much Sir.