cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DinaRamalho
New Member

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

.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors