Forum Discussion
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 colum...
PaulDBrown
Community Champion
Community ChampionI'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