Forum Discussion
Column from Different Tables
Hey guys, very noob question. I have two tables with two costs columns. Like this: [Table1] ID - Cost 01 - 100 02 - 200 03 - 300 [Table2] ID - Cost 01 - 110 02 - 220 03 - 300 Wha...
Hello,
usually they should be mergable in Power Query. Are both ID columns formatted the same without any spaces or similar?
Nevertheless you can relate the two ID columns.
If both columns contain unique values you can just add a calculated column =[Cost]-Related(ID_Cost2[Cost]).
It is depending of the direction of your relation in which table you are able to add the RELATED.
Hi Floriankx
I tried creating the calculated column =[Cost]-Related(ID_Cost2[Cost]), but it did not work.
I have both tables connected through a fact table, like this:
[Table1] N -------1[Fact]1-------N[Table2]