Creating a custom column to tag items from two separate tables

Question

&nbsp;Hi,&nbsp;I am trying to create a column where I want to create a tag coming from two separate columns. I'm not really sure if the SWITCH function would fit my need. Hoping you could help me on this one. Here's the sample of my table:&nbsp;From that table, I wanted to create a contactability column where I'm supposed to tag those that have a mobile and email into one. For the picture above, I wanted to tag it as NO EMAIL AND SMS given that the columns Mobile and Email contains NULL.&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous,&nbsp;You can use the below Formula to create a new&nbsp;Calculated Column :&nbsp;&nbsp;Contactability = if(AND(SampleData[Mobile] = "NULL",SampleData[Email] = "NULL"),"NO EMAIL AND SMS",
    
    if(and(SampleData[Email] = "NULL",SampleData[Mobile] &lt;&gt; "NULL"),"SMS Only","EMAIL Only"))&nbsp;If I answer your question! Mark my post as a solution!&nbsp;&nbsp;Thanks,Jayant

anonymous · Answer

Hi Anonymous! Thank you so much for the response. It is finally working. However, how about for instances where one column has a value and the other one has none, how do I code it?

Using the same table, I would also like to tag those with SMS Only, Email Only and with SMS and Email. For SMS only, if there is a mobile number present and the email is NULL and vice versa for Email Only tag. Hope you can help me on this one. Thank you!

anonymous · Answer

Hi&nbsp;Anonymous,&nbsp;This Code will cover up all the scenarios:&nbsp;Contactability = if(AND(SampleData[Mobile] = "NULL",SampleData[Email] = "NULL"),"NO EMAIL AND SMS",
    
    if(and(SampleData[Email] = "NULL",SampleData[Mobile] &lt;&gt; "NULL"),"SMS Only","EMAIL Only"))The above code will cover the Scenario :If There is value in Email Column only then the Tag will be Email OnlyIf there is value in Mobile Column only then the Tab will be Mobile OnlyIf there is no value in either column then Tag will be NO EMAIL AND SMS&nbsp;&nbsp;The DAX that I have mentioned above contails all the Scenarios, try that in your dataset and see if you Get the result. I tried with the dataset and it is giving me the required result.&nbsp;If I answer your question! Mark my post as a solution!&nbsp;&nbsp;Thanks,Jayant&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous! What about if Mobile and Email column contains "NULL" where the tag should be No SMS and EMAIL whereas the Mobile and Email column both contains an item and the tag should be With SMS and EMAIL?

anonymous · Answer

Anonymous,&nbsp;in that case this&nbsp;should work :Contactability = if(AND(SampleData[Mobile] = "NULL",SampleData[Email] = "NULL"),"NO EMAIL AND SMS",
				if(AND(SampleData[Email] = "NULL",SampleData[Mobile] &lt;&gt; "NULL"),"SMS Only",if(AND(SampleData[Email] &lt;&gt; "NULL",SampleData[Mobile] = "NULL"),"EMAIL Only","With SMS and EMAIL")))&nbsp;If I answer your question! Mark my post as a solution!&nbsp;&nbsp;Thanks,Jayant

Forum Discussion

Creating a custom column to tag items from two separate tables

10 Replies

Related content

How creating a Python custom library

Creating a custom column

Thousand-Separator-and-Decimal-Separator

To create a filter using comma separated field.

Architecture decision : Separate workspaces