Forum Discussion
Powe query
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
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.
3 Replies
Hi r8_k9 ,
Based on your explanation and example, if the formula below what you after?
Table.SelectRows(table, each [column2] = 1)
Regards
KT
Tried this, Its throwing error " A table of multiple values was supplied where a single value was expected"
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.
