Subtract Actual Log Hours from Target on Multiple Tables

[Anonymous]

HI All, PowerBI Newbie here. I am trying to subtract the total log hours from an job operation from the target of that operation.

I'm combining a couple tables;

Target Table

Operation 1 - 5 hrs

Operation 2 - 4 hours

Log Table

Operation 1 - 0.5 hrs

Operation 1 - 4 hrs

Operation 2 - 2 hrs

Operation 2 - 2 hrs

The resulting table I have so far looks like this;

Operation    - Target - Log Hours

Operation 1 - 5 hrs   - 4.5 hrs

Operation 2 - 4 hrs   - 4 hrs

The table I am looking for subtracts the actual from the target;

Operation    - Target - Log Hours  - Difference

Operation 1 - 5 hrs   - 4.5 hrs        - 0.5 hrs

Operation 2 - 4 hrs   - 4 hrs           - 0.0 hrs

I've been working on this for days and would great appreicate help from the community!

Thanks all, 

[AlB · Accepted solution]

Hi @Anonymous

I'm not quite sure I understand correctly what you are looking for but it seems a simple calculated column like

Table[Difference] =Table[Target] - Table[Log Hours]

would do the job?

[Anonymous]

This worked! I also set the tables as bi-directional.