Forum Discussion
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...
Pragati11 , I need a new column with filter in the formula inside, that in the future I could add several columns like that but with different filters into my table visual. Otherwhise, If I'm using one filter (slicer) to whole table visual, it affects all columns. But I don't need that.
If this is your requirement, as Pragati11 said, only solution is to add new columns to your table like:
Column2 = IF('Table1'[Column1] = "A", 'Item'[Column1], " ")
Column3 = IF('Table1'[Column1] = "B", 'Item'[Column1], " ")