Forum Discussion
Profit Report
Hi there I need to build a profit report as I have 3 tables as the following: A- Table 1 contains: 1- Revenue amount 2- Revenue Date 3- Project ID ...
Hi Anonymous ,
To create another new calculated table as a bridge table, and create relationship between your fact tables.
Project = DISTINCT ( UNION ( VALUES ( table1[projectid] ), VALUES ( table2[projectid] ), VALUES ( table3[projectid] ) ) )
ImkeF
Community Champion
Community ChampionHi Anonymous
I'd recommend to create a Project table as well. That will be connected by the Project ID and the Date table just by the Date columns.
Recommended reading: https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/