Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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:

Screenshot (255).png

 

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

Screenshot (257).png

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

Screenshot (258).png

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

 

 

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

Syndicated - Outbound

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:

model.PNG

 

 

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.






VijayP
Super User
Super User

Syndicated - Outbound

@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!


avatar user
Anonymous
Not applicable

Syndicated - Outbound

@VijayP I did it but it is doubling my values

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)