Forum Discussion
Append multiple fact tables into one or keep them seperated?
Hi Anonymous ,
To get all the fact tables, we will get a huge table. The size of the file will be bigger. Also, in that way, be wary of DAX functions, which need to test every row in a table – for example, RANKX – in the worst case, these functions can exponentially increase run-time and memory requirements given linear increases in table size.
So keeping them seperated is prefered. We can use dimension tables to link to the fact tables. DAX will calculate the measures against the common dimensions and then let you compare the results for the different fact tables in the same analysis. Please refer to the article here.
https://powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/
Community SupportHi Anonymous ,
To get all the fact tables, we will get a huge table. The size of the file will be bigger. Also, in that way, be wary of DAX functions, which need to test every row in a table – for example, RANKX – in the worst case, these functions can exponentially increase run-time and memory requirements given linear increases in table size.
So keeping them seperated is prefered. We can use dimension tables to link to the fact tables. DAX will calculate the measures against the common dimensions and then let you compare the results for the different fact tables in the same analysis. Please refer to the article here.
https://powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/