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
32 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
• 42,510 points
70 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,550 points
331 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
• 31,840 points
465 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
• 31,840 points
7,383 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
• 42,510 points
53 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
• 42,510 points
85 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
• 42,510 points
63 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
353 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 97 views