Forum Discussion

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

Super User

5 years ago

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

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
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
  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.
  - Pragati11
    Super User
    5 years ago
    Hi gduobaite ,
    
    Is the requirement on getting this new column is in your source data?
    
    If not then just drag COLUMN1 to a table visual --> Create a slicer on COLUMN1 --> select values in slicer -- Table visual will get updated based on slicer selection.
    
    If this is not the case then please add more detail with th example as your 1st example is not clear enough to answer your query.
    
    Thanks,
    
    Pragati

Related content