How to Filter a Query?

Question

Hi,

Let the DAX be

    Source = Excel.CurrentWorkbook(){[ Name =" Sales"]}[ Content],

    FilteredRows = Table.SelectRows( Source, each ([     Product] = ProductQuery[ Product]{ 0}))

How do I filter a query from a particular field from another query, Power BI ?

Answer 1

Hi,

You can do the same in Power BI Designer

Following are the steps which you can follow:

1. Goto Get Data

2. Select "Blank Query"

3. Enter the code Source = Excel.CurrentWorkbook(){[ Name =" Sales"]}[ Content],

    FilteredRows = Table.SelectRows( Source, each ([     Product] = ProductQuery[ Product]{ 0}))

Hope This Helps!!