cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 IV
Super User IV

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 IV
Super User IV

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 IV
Super User IV

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

 

Highlighted
gidon Regular Visitor
Regular Visitor

Re: Reduce data

thank you very much

gidon

 

Super User IV
Super User IV

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

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

Top Solution Authors
Top Kudoed Authors