Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to Add a New value in an existing Column?

Hi All,

 

I have a Column named "Category" which consists of two values (Say) A and B. Now I need to add an additional value called "C" without any condition. My Problem is that I cannot use Custom column or conditional column, because there is no underlying condition available. My basic requirement is to additionally add one more category called "C" into the column "Category" which is already available. How to achieve that?

 

Please post your views on this requirement. Thanks in advance !! 

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Anonymous 

     

    you can use UNION dax code to create a new table and add a new value to category column:

    Table 2 =
    Union('Table',row("Category","C"))



    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

     

1 Reply

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    you can use UNION dax code to create a new table and add a new value to category column:

    Table 2 =
    Union('Table',row("Category","C"))



    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/