I have 3 Fact Tables I would like to combine them into 1, I am not sure what's the best way to do it.
In Adventure Works, it uses UNION in TSQL to create a sales_summary Fact from Internet Sales and Reseller Sales.
Can I just write a simple Calculated measure? What's the best way to handle this kind of situation?
[Distribution Partner].[Distribution Partner].[DP]