How to Add a New value in an existing Column?

[Anonymous]

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 !! 

[VahidDM · Accepted solution]

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/