cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gidon Regular Visitor
Regular Visitor

Reduce data

Hello

 

when I load a table I want to reduce Part Numbers

according to falg given on differnt table

this ia my data  and reduce flag table

I want to load only parts with Reduce = 'n'

( this table is only a sample my tables includes millions of data lines , and about 50000  part

 

thanks

gidon

 

this is the flag table

partReduce
100n
200y
300n
400y

 

 

 

this is tha data table   

partcustQuantUnitPCUR
1001100050010/10/15
2003550060011/11/14
3006700070012/12/15
20071500080003/15/13
1008900040003/12/11
2009900030003/12/09
3001900020003/12/07
4003900025008/15/12
10069000500

07/07/17

    

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Reduce data

In Power Query editor (Edit Queries), select your main query. Go to the last step in that query. All the way to the right you should see "Merge Queries". Click that. It will bring up a dialog allowing you to select the common columns and pick what kind of join you want.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Reduce data

So, you need to do a Merge Table step in your main query where you merge your two tables. Then, you can easily filter out the "Reduce = 'n'" rows by selecting the dropdown for that column and unselecting everything by "n".


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

gidon Regular Visitor
Regular Visitor

Re: Reduce data

hi

thanks for your fast response

 

how do i Merge those two tables

 

thanks

 

gidon

 

 

Super User
Super User

Re: Reduce data

In Power Query editor (Edit Queries), select your main query. Go to the last step in that query. All the way to the right you should see "Merge Queries". Click that. It will bring up a dialog allowing you to select the common columns and pick what kind of join you want.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

gidon Regular Visitor
Regular Visitor

Re: Reduce data

will try and advice

thanks

gidon

 

gidon Regular Visitor
Regular Visitor

Re: Reduce data

thank you very much

gidon

 

Super User
Super User

Re: Reduce data

No problem! Glad it met your need!


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)