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 13, 2019 in Power BI by Phalguni
• 1,010 points
37 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,500 points

Related Questions In Power BI

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
• 49,700 points
84 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,570 points
400 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
• 32,420 points
631 views
+3 votes
1 answer

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 32,420 points
10,900 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
• 49,700 points
61 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
• 49,700 points
90 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
• 49,700 points
79 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 10, 2019 in Power BI by Avantika
• 1,500 points
556 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,500 points

edited May 17, 2019 by Omkar 144 views