Filter a Query

[DinaRamalho]

Hi,

How can I filter my query from a particular field of another query, Power BI Designer?

In excel i use:

let

    Source = Excel.CurrentWorkbook(){[ Name =" Sales"]}[ Content], FilteredRows = Table.SelectRows( Source, each ([     Product] = ProductQuery[ Product]{ 0}))

in

  FilteredRows

Thanks

.

[Anonymous · Accepted solution]

You should be able to do exactly the same in Power BI Designer.
Just from Get Data select "Blank Query", then copy and paste the code above and should be good to go.