Forum Discussion

adityavighne's avatar
adityavighne
Continued Contributor
7 years ago

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(except) A, C, D, G, H

 

I need output like - 

Channel
B
E
F
I
J
K
L
Need Help

3 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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.