Converting DAX code into M

[Dunner2020]

Hi there,

I have a column which I created using the DAX function. I wanted to create the same column in the power query editor (and want to get rid of the column created using DAX). 

Month Number = SWITCH([Month Name],

"April",1,

"May",2,

"June",3,

"July",4,

"August",5,

"September",6,

"October",7,

"November",8,

"December",9,

"January",10,

"February",11,

12

)

When I applied the same formula in power query editor I got the following error:

However, I got the following error:

Could anyone help me in converting DAX code into M language?

[v-diye-msft]

Hi @Dunner2020 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.

[NamishB]

Hi @Dunner2020- I am not sure if i got this right but are you trying in power Query Editor to convert MonthName to Numbers. 

I added a new Column from Example and mapped the months, M Code generated itself was something on the lines: 

= Table.AddColumn(#"Renamed Columns", "Custom", each if [Month Name] = "Jan" then 10 else if [Month Name] = "Feb" then 11 else if [Month Name] = "Mar" then 12 else if [Month Name] = "Apr" then 1 else if [Month Name] = "May" then 2 else if [Month Name] = "June" then 3 else if [Month Name] = "July" then 4 else if [Month Name] = "Aug" then 5 else if [Month Name] = "Sep" then 6 else if [Month Name] = "Oct" then 7 else if [Month Name] = "Nov" then 8 else if [Month Name] = "Dec" then 9 else null, type number)

and i then removed the MonthName column

Does this help?

[amitchandak]

@Dunner2020 , same thing as been done and explained nicely in this article -https://www.thebiccountant.com/2018/02/15/generic-switch-function-query-editor-in-power-bi-and-power...

[VasTg · Accepted solution]

@Dunner2020 

Try the conditional column and assign your appropriate value. The below image is just an example.

If it helps, mark it as a solution

Kudos are nice too