Courses / Power Query (Get & Transform)
12. Table.SelectRows
Filtering rows by conditions using the UI filters or Table.SelectRows in M.
1 min read Chapter 12 of 43
Power Query M
Table.SelectRows
A function that keeps only the table rows that satisfy a condition you give it.
"I only want the rows that matter — drop the rest automatically."
Table.SelectRows takes a table and a predicate (a function returning true/false for each row) and returns a new table containing only rows where the predicate is true.
"I only want the rows that matter — drop the rest automatically."
Table.SelectRows takes a table and a predicate (a function returning true/false for each row) and returns a new table containing only rows where the predicate is true.