Forum Discussion

DinaRamalho's avatar
DinaRamalho
New Member
11 years ago
Solved

Filter a Query

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's avatar
    Anonymous
    11 years ago
    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 years ago
    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.