Switch Function help

[Anonymous]

I am trying switch function to create a new column.

SWITCH(Query1[Month_New],"January",01,"February",02,"March",03,"April",04,"May",05,"June",06,"July",07,"August",8,"September",9,"October",10,"November",11,"December",12)

in output i am not geeting 01 for janurary. I am getting 1 only

[az38]

Hi @Anonymous 

try to use quotas

SWITCH(Query1[Month_New],
"January","01",
"February","02",
...,
"12")

[Anonymous]

It is not working 

[az38 · Accepted solution]

@Anonymous 

also change column type to Text in Column tools ribbon

[Anonymous]

Thanks for the solution