Add column from another Table

Question

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 Copy, it will displayed in every row.Latest Date eg. 5 rows. I only need to get 1 row record.DateTotal SalesIDT27/4/231005027/4/231005027/4/231005027/4/231005027/4/2315050TOTAL:550&nbsp;&nbsp;Actual Total = [Total Sales]- [IDT]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 550 – 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 500Can someone suggest how to solve this? or any simple solution for this?Thank you

lbendlin · Answer

I added “Table_B” column (IDT) to Table_A.
Please explain that decision.&nbsp; 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).&nbsp; In most cases the correct approach is to fix the data quality of your dimension table.

mmquestions7 · Answer

Hi, Thank you for the suggestion. I managed to do it using measure. thank you.

Forum Discussion

Add column from another Table

2 Replies

Related content

[PowerQuery] add (same) column from another table

How to add another column from another table?

Sort by another column

Column created in a table appears in another table

Copy column from one table to another table

Date	Total Sales	IDT
27/4/23	100	50
27/4/23	100	50
27/4/23	100	50
27/4/23	100	50
27/4/23	150	50
TOTAL:	550