Search code examples
t-sqlpowerbipowerquerym

How can I turn the next query into Power Query, I can only perform the first part

How can I turn the next query:

SELECT Column1, Column2 FROM Table WHERE Column3 < 15

Into Power Query M, I can only perform the first part:

= Table.SelectColumns(#"Table", {"Column1", "Column2"})
Solution

  • If you prefer single step:

    = Table.SelectRows(Table, each [Column3] < 15)[[Column1],[Column2]]