Create New Query Based on a Column In Another Query

[msedlak]

Hello,

I have three queries:

1) Customers with customer information

2) Providers in Network

3) Provider Prospects

I have done a cross join to join queries 1 and 2 then used a distance formula to determine if a provider in network covers a customer location.  If they are covered I bulit a new column that labels row yes or no.

I would like to build a 4th query that is filled only with rows labeled no from query 1.

How do I accomplish this?

Thank you,

Mark

[Greg_Deckler]

If you want to do this in Power Query, then you would create a query that references your other query. Right click query 1 and choose Reference. Then you would filter for no.

In DAX, you would create a new table with a formula like:

Table 4 = FILTER('Table 1',[Label] = "No")

[amitchandak]

You can create a new column in table using other tables like

.

New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])
New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project]),table2[name])

new Column =
LOOKUPVALUE('Table'[Lot No.], 'Table'[Entry Type], "Output", 'Table'[Document No.], firstnonbank('Table'[Document No.],true()))
OR
new Column =
minx(filter('Table', 'Table'[Entry Type]= "Output" && 'Table'[Document No.]= earlier('Table'[Document No.])),'Table'[Lot No.])

In case it does not help

Can you share sample data and sample output.