Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
part | Reduce |
100 | n |
200 | y |
300 | n |
400 | y |
this is tha data table
part | cust | Quant | UnitP | CUR |
100 | 1 | 1000 | 500 | 10/10/15 |
200 | 3 | 5500 | 600 | 11/11/14 |
300 | 6 | 7000 | 700 | 12/12/15 |
200 | 7 | 15000 | 800 | 03/15/13 |
100 | 8 | 9000 | 400 | 03/12/11 |
200 | 9 | 9000 | 300 | 03/12/09 |
300 | 1 | 9000 | 200 | 03/12/07 |
400 | 3 | 9000 | 250 | 08/15/12 |
100 | 6 | 9000 | 500 | 07/07/17 |
|
Solved! Go to Solution.
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.
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".
hi
thanks for your fast response
how do i Merge those two tables
thanks
gidon
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.
will try and advice
thanks
gidon
thank you very much
gidon
No problem! Glad it met your need!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |