Forum Discussion

r8_k9's avatar
r8_k9
New Member
3 years ago
Solved

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 s...
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
3 years ago

Hi r8_k9 ,

 

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

 

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

 

Regards

KT