cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RenataOGardner
Helper I
Helper I

New column

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!

Capture_DAX_CondColumn.JPG

1 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

View solution in original post

6 REPLIES 6
Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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!

So something like:

 

Column =

  SWITCH('Table'[Column],

    "39062","John Lewis",

    "39063","John Lewis",

    <as many pairs as you want>

  )

 

 

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hiya, 

 

Thanks for helping me. Much appreciate it. 

Unfortunately, it doesn't like the SWITCH either. 

Capture_DAX Switch function error.JPG

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

View solution in original post

Thank you so much! 🙂

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors