undefined

[Anonymous]

I have a three column i want a result like it select" T " from col1- and that should not contain 0 and null from col2 and col3 
col1    col2   col3           
A         1        null 
A         2         0
T        3          0
T       0          null
T       null      6

[v-mengzhu-msft]

Hi @Anonymous ,

what's your meaning of "not contain 0 and null from col2 and col3",from your description, I know you want to filter col1，but I don't understand "not contain o and null", because unless you delete col2 and col3, if you filter on this table, it will show the whole row.

So can you give me your expected result? so that i can know what you want.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In the Query Editor, right click on the first column's heading and select "Unpivot Other Columns".  Filter the Value column with the criteria >0.  Does this help? 

[Greg_Deckler]

@Anonymous Maybe:

col4 = 
  SWITCH(TRUE(),
    [col1] = "T" && [col2] > 0 && [col3] > 0, TRUE(),
    FALSE()
  )