Forum Discussion
How to create except row value column
How to create except row value column? I have a column with values Channel A B C D E F G H I J K L want to create a new column where I don't want(e...
Hi adityavighne
If you want it in another table, you can create a new calculated table:
NewTable = FILTER(Table1, NOT Table1[Channel] IN { "A", "C", "D", "G", "H"})
or alternatively:
NewTable2 = EXCEPT(ALL(Table1[Channel]),{ "A", "C", "D", "G", "H"})
If you want it in a table visual you can ust use the visual level filters and deselect the letters you don't want shown.
I don't want to create a new table. this is not working.
