Forum Discussion

gduobaite's avatar
gduobaite
Helper III
5 years ago

Add new column

Hi,    how can I create a whole new copied column in the same table with added filters inside?   I have:   Column1 A B B C   I need a new column with only B values:   N...
Need Help
Pragati11's avatar
Pragati11
Super User
5 years ago

Hi gduobaite ,

 

You can just use a DAX expression to create a new column:

NewColumn = IF(tablename[Column1] = "B", "B", " ")

 

Replace tablename in above DAX with your table name.

 

Thanks,

Pragati

  • gduobaite's avatar
    gduobaite
    Helper III
    5 years ago

    Hi, Pragati11 , 

     

    you see, I have many values in my column, over 15k rows, so it's impossible to use IF function and type each row by row. 😞

    I need a copied column with filters inside.

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      Hi gduobaite ,

       

      How many unique values do you have in this COLUMN1 in your real data-set?

      From these unique values, how many of them you want to replace in NewColumn?

       

      Thanks,

      Pragati

      • gduobaite's avatar
        gduobaite
        Helper III
        5 years ago

        Dear Pragati11, 

         

        I have 7k unique values in Column1.

        I don't want to replace anything in my new column, just add a filter from other column and get a new column with filtered values. 

         

         

        Copy all values from Column1 into my new column with added filter (or condition, I don't know) where Event name = "result clicked" and thats how get a whole new column with filtered values which are only result clicked.