Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
Try using Left Out based on one similar column in both tables.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |