Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
Show and Tell
Tutorial Requests
Floriankx's avatar
Floriankx
Solution Sage
8 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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]

     

     

    • Floriankx's avatar
      Floriankx
      Solution Sage
      8 years ago

      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.