Powe query

[r8_k9]

I have table with 12 columns, i want to filter out the values from 1st column based on the records of the 2nd column.

ex:

column1     column2

xxx                  1

yyy                  0

i should get xxx because i have 1 in column 2

Kindly help me with this

[v-jingzhang · Accepted solution]

Hi @r8_k9 

To filter rows, you can click the DownArrow icon on column header of the second column and select only 1 in the listed values. Then click OK. Is this what you want?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[r8_k9]

Tried this, Its throwing error " A table of multiple values was supplied where a single value was expected"

[KT_Bsmart2gethe]

Hi @r8_k9 ,

Based on your explanation and example, if the formula below what you after?

Table.SelectRows(table, each [column2] = 1)

Regards

KT