topic New column in DAX Commands and Tips

New column

RenataOGardner — Mon, 23 Mar 2020 12:34:46 GMT

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!

Re: New column

Greg_Deckler — Mon, 23 Mar 2020 12:19:18 GMT

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

Re: New column

RenataOGardner — Mon, 23 Mar 2020 12:39:07 GMT

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!

Re: New column

Greg_Deckler — Mon, 23 Mar 2020 12:42:45 GMT

So something like:

Column =

SWITCH('Table'[Column],

"39062","John Lewis",

"39063","John Lewis",

)

Re: New column

RenataOGardner — Mon, 23 Mar 2020 12:50:30 GMT

Hiya,

Thanks for helping me. Much appreciate it.

Unfortunately, it doesn't like the SWITCH either.

Re: New column

HotChilli — Mon, 23 Mar 2020 13:40:55 GMT

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

Re: New column

RenataOGardner — Mon, 23 Mar 2020 14:25:16 GMT

Thank you so much! 🙂