Forum Discussion
Solved
Data Model - Consolidating Multiple Fact Tables
I am somewhat new to power BI and am building a data model that uses multiple fact tables and would like your best practices to maximize resource efficiency of the model. The data model is compos...
PB76 , In such case we usually append all tables (Usually we do not append date table, but possible to do so).
All Tables need to have a company id. Now if you want to do a full exercise in power query, you need to add an index column in the dimension tables table, then merge and populate the ID back
You can refer: https://youtu.be/vHuhbvYCiNc
PB76 , In such case we usually append all tables (Usually we do not append date table, but possible to do so).
All Tables need to have a company id. Now if you want to do a full exercise in power query, you need to add an index column in the dimension tables table, then merge and populate the ID back
You can refer: https://youtu.be/vHuhbvYCiNc