- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Merge fact tables
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!
Proud to be a Super User!
Paul on Linkedin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Try using Left Out based on one similar column in both tables.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-14-2024 01:41 PM | |||
10-13-2024 06:37 AM | |||
09-04-2024 12:50 AM | |||
11-13-2024 05:45 AM | |||
11-11-2024 09:06 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |