Combine two tables

[dennis1994]

Hello,

I would like to combine table 1 and table 2 from my photo, so that i end up like table 3. i dont quit get it. Can someone help me please?

Regards

Dennis

[acanepa]

Hello @dennis1994,

You could use Crossjoin and filter to solve you issue.

I have created a sample workbook for replicating your data.

Table 3 is the example of what you want to achieve.

Table 1

Table 2

Table 3

 Code:

Table 3 = filter(
 CROSSJOIN(Table1,Table2),[id]=[id2] && [Date] =[Date2])

I get the information from the following link:

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Sample Workbook

https://ufile.io/rt1ae

Regards,

[dennis1994]

Hello acanepa,

 Thanks for the fast reply. Where exactly do i need to input the code? When i try to create a new table i get following error:

[dennis1994]

Ok i found my mistake.

The outcome is not completely how i would like to have it. What i get is a table with 7 rows:

What i want is a table with just 4 rows and the added column. As for several dates there are multiple rows in both tables, i get more rows then i want, what later falsifies my measures.

Another way i could think of is to "sum" table 1 something like:

If there are multiple values of column x for one date (e.g.: 09.01 has value 1 and value 0 -->two differnt rows) sum them so that there is just one row for that date

Something like this:

[acanepa]

Hi @dennis1994

You need to change the column name "dri_exact_date" in one of the tables, the formula does not allow two columns with the same name.

You could use SELECTCOLUMNS for filtering columns.

Regards,

[Rfranca · Accepted solution]

hi, @dennis1994 @acanepa

1. Import the data from TABLE1
2. Import the data from TABLE2
3. Edit the query in TABLE2 and remove the duplicates
4. Combine tables TABLE1 and TABLE2
5. Group the values (as pictured)

Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
 
Best Regards,
Rfranca