Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Select all rows of a column with Table.SelectRows function in PowerQuery Editor

Hi Everybody,   I have recently opened this thread in order to find whether there is the possibility to select every rows of a column, according to multiple conditions.   I'll explain here. Supp...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , Based on what I got

. You can use the Table.AddColumn function to create a new column that duplicates the values from column B and then filter it based on your conditions.

 

Power BI- Power Query Table.AddColumn- https://youtu.be/dEDK4wktAME

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi amitchandak, that's not the solution, I need to filter that column, so I need a condition that specify "Filter column B taking everything in it", a sort of Select All.

     

    Is there any script?

     

    D