Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query Editor Custom Column: If, Then Formula

Hi:

I'm trying to create a custom column in Power Query Editor with an if, then formula based on a field called "Month".  "Month" holds the name of the month such as "January", "February", etc.

I want the custom column to show the number of the month.

So, please help me correct the syntax below, since it's not working:

IF [Month] =
"August" Then 8
ELSE IF "December" Then 12
ELSE IF "July" Then 7
ELSE IF "November" Then 11
ELSE IF "October" Then 10
ELSE IF "September" Then 9
ELSE IF "April" Then 4
ELSE IF "February" Then 2
ELSE IF "January" Then 1
ELSE IF "March" Then 3
ELSE IF "May" Then 5
ELSE IF "June" Then 6

Thanks!

John

Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    Sorry, no it doesn't. It'll be the same as you have, so 

    if [Month] = "August" then 8
else if [Month] = "December" then 12
else if [Month] = "July" then 7
else if [Month] = "November" then 11
else if [Month] = "October" then 10
else if [Month] = "September" then 9
else if [Month] = "April" then 4
else if [Month] = "February" then 2
else if [Month] = "January" then 1
else if [Month] = "March" then 3
else if [Month] = "May" then 5
else if [Month] = "June" then 6

3 Replies

  • AntonioM's avatar
    AntonioM
    Solution Sage
    4 years ago

    In power query, "if", "else" and "then" all need to be lower case

     

    Each time you have a new "if" you need a full condition to check, so each time you'll need to type '[Month] = ', so 

    [Month] = "December" then 12 else if [Month] = "July" then 7 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks!  Does the beginning of the syntax start with [Month]?

      • AntonioM's avatar
        AntonioM
        Solution Sage
        4 years ago

        Sorry, no it doesn't. It'll be the same as you have, so 

        if [Month] = "August" then 8
else if [Month] = "December" then 12
else if [Month] = "July" then 7
else if [Month] = "November" then 11
else if [Month] = "October" then 10
else if [Month] = "September" then 9
else if [Month] = "April" then 4
else if [Month] = "February" then 2
else if [Month] = "January" then 1
else if [Month] = "March" then 3
else if [Month] = "May" then 5
else if [Month] = "June" then 6