Forum Discussion
MMQuestions7
3 years agoRegular Visitor
Add column from another Table
Hi, I have 2 tables (with relationship) – Table_A, Table_B. I added “Table_B” column (IDT) to Table_A. IDT Copy = RELATED(Table_B[IDT]). The issue is Table_A consists of Dates and when IDT Co...
lbendlin
3 years agoSuper User
I added “Table_B” column (IDT) to Table_A.
Please explain that decision. Pulling dimension fields into a fact table should be limited to scenarios where it is absolutely required (for example when you have non-covering or degenerate dimensions). In most cases the correct approach is to fix the data quality of your dimension table.