How to Filter a Query

0 votes
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 ?
Jun 14, 2019 in Power BI by Phalguni
• 1,020 points
369 views

1 answer to this question.

0 votes
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!!
answered Jun 14, 2019 by Avantika
• 1,520 points

Related Questions In Power BI

0 votes
0 answers

How to create a new slicer to filter data by district manager in Power BI?

Can anyone create a new slicer to ...READ MORE

Feb 6, 2020 in Power BI by Roshni
• 10,520 points
695 views
0 votes
1 answer

How to assign Power BI license to a new user

The assign license method of MS Graph API might ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 52,350 points
597 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,021 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 33,030 points
3,921 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
675 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
632 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
900 views
+1 vote
1 answer
0 votes
1 answer

How to use Python Scripts in Query Editor?

Hi, In order to use Python Visuals you need ...READ MORE

answered Apr 11, 2019 in Power BI by Avantika
• 1,520 points
3,270 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by Avantika
• 1,520 points

edited May 17, 2019 by Omkar 6,897 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP