Merge fact tables

[Anonymous]

Hello Guys,
Can anybody help me? Please! I've been trying for days and I can't.

The fCustoInvestimento table has all marketing campaign costs by date. I would like to bring to this table some columns from the fPipes table such as the 'Valor Deal', 'Etapa', 'Estrategia and 'Produto' columns.

Below is the modeling:

I merged the CustoInvestimento table with the fPipes table and performed the InerJoin but it ends up duplicating the rows with the s value below

The correct value would be the one in the image below. The Campaign/Ad Set/Ad from the CostInvestment table has only two rows of records in the fPipe table

I want to make just a table so I can filter by any column at the campaign/ad set/ad level by date.

https://ufile.io/x1zb7uvr

[PaulDBrown]

I'm not sure why you need to add columns from one table to another. In theory, if you set up the model correctly, you don't need to. I would recommend you delete the many-to-many relationship between the dCampanha table and the fact tables and create seperate dimension tables as follows:

You can now use these dimensions for your visuals, filters slicers and measures and include fields from either table based on the common dimension.

I've attached the sample file for you

[VijayP]

@Anonymous 

Try using Left Out based on one similar column in both tables.

[Anonymous]

@VijayP I did it but it is doubling my values