New column

[RenataOGardner]

Hello guys,

I'm trying to create a column where a list of customer numbers is related to the customer name, but I can't add more than 3 argument for the function below. All the numbers below should give "John Lewis" as answer. Can anyone help me out? Cheers!

[Greg_Deckler]

You could use nested IF statements, but don't. Use SWITCH instead but I can't exactly tell what you are trying to do. 

[RenataOGardner]

Hi,

What I'm trying to do is: Create a column with the name of the Custormer and add all the locations that are under this customer. The locations are coded by number so each number I want to call for the name of the customer. 

Thanks!

[Greg_Deckler]

So something like:

Column =

  SWITCH('Table'[Column],

    "39062","John Lewis",

    "39063","John Lewis",

    <as many pairs as you want>

  )

[RenataOGardner]

Hiya, 

Thanks for helping me. Much appreciate it. 

Unfortunately, it doesn't like the SWITCH either. 

[HotChilli · Accepted solution]

The syntax is wrong.   Replace that = with a ,

And check that the data type of [no_] is text.  If it is of number type then you don't need the quotes round the hardcoded values

[RenataOGardner]

Thank you so much! 🙂