Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Switch Statement not working to create a new column

I want to create a new column in my data, based off the value of an existing column.  I did not want to use an if statement, because would have to use about 9 nested statements and that is soooooo me...
Need Help
  • jdobrzen's avatar
    jdobrzen
    8 years ago

    Maybe try trimming PMO_Time[Project Number], just in case there's a space or something in front/behind it.  Maybe it needs to be padded with zeros or something else?

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Is the data type of your project number field a number or text? If it's the former try getting rid of the "s around your project numbers

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for your reply.  The data type is text.  Additionally, PowerBi does not return any errors when I save the statement.