Combine two tables, filtering out duplicates from table two.

0 votes
I want to combine two tables into one. My first table has 3 columns: ID, Split, Program. my second table have "ID, Program, the split for the second table will be a 100% by default. The combined table has to have all the entries from table one and from table two only the entries that are not in table one. ID in table one is repeated multiple times with different percent split and program...

The whole exercise goal is: I have a dataset with ID and expenses by program, but some of those expenses are split over multiple programs which are calculated based on an external table which contains the split. So my end result should contain the original data set with only a few ID expenses split over more than one program.
May 12 in Power BI by Nikola
• 140 points
166 views
Hey, @Nikola,

You can do one thing, use the merge option and then select  NA and append.

I hope this will work.

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,460 points
3,392 views
0 votes
1 answer

Add Column Count_of_people across two tables to get the count of people from a city.

Hi Anitha, 1. Merge both tables, using City ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,460 points
72 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,200 points

edited Oct 11, 2018 by Kalgi 478 views
0 votes
1 answer

Select Columns from table instead of removing afterwards in Power Query

Try this. let db = Sql.Databases("sqlserver.database.url"){[Name="DatabaseName"]}[Data], Sales_vDimCustomer = ...READ MORE

answered Oct 31, 2018 in Power BI by Shubham
• 13,380 points
720 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,010 points
380 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, 2019 in Power BI by Cherukuri
• 32,460 points
1,333 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,010 points
271 views
0 votes
1 answer

How to combine multiple tables in power BI?

Hi Sindhu, You can merge the 3 tables ...READ MORE

answered Mar 14, 2019 in Power BI by Cherukuri
• 32,460 points
6,616 views
0 votes
1 answer

Adding values of two columns in two tables

Hi Anshuli, You can either create a separate ...READ MORE

answered Apr 10, 2019 in Power BI by Cherukuri
• 32,460 points
87 views
0 votes
1 answer

Profile all the data tables

you can automatically get a profile for ...READ MORE

answered Sep 20, 2018 in Power BI by Kalgi
• 51,850 points
49 views