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 in Power BI by Phalguni
• 1,010 points
20 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 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
• 40,460 points
56 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,530 points
253 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 in Power BI by Cherukuri
• 25,900 points
302 views
+1 vote
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 in Power BI by Cherukuri
• 25,900 points
3,801 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
• 40,460 points
41 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
• 40,460 points
77 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
• 40,460 points
56 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 in Power BI by Avantika
• 1,500 points
172 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 in Power BI by Avantika
• 1,500 points

edited May 17 by Omkar 76 views