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...
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]
Hello,
I assume you add your calculated table in the Fact Table.
The relations have to be the other way arround. So you need to drag the Fact ID on the data ID.
I don't how excatly this works with the direction of the relations but I know it works this way.
Regarding your Problem in Power Query it would be helpful to know which error is shown.