Forum Discussion
Calculated Column - 2 Tables
Looking for help with a calculated column between two different tables. The end goal is for the calculated column to be: (Hours at Completion) - (Travel Time) Hours at Completion is on one ta...
If Table 1 is on the many side, you can use this expression to get your result
NewColumn = Table1[Hours at Completion] - RELATED(Table2[Travel Hours])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Table 1:
| Project Code | Hours at Completion |
| Project A | 90 |
| Project B | 80 |
| Project C | 102 |
Table 2:
| Project Code | Travel Hours |
| Project A | 5 |
| Project B | 0 |
| Project C | 4 |
Desired Output: (Hours at Completion - Travel Hours)
| Project Code | (Hours at Completion - Travel Hours) |
| Project A | 85 |
| Project B | 80 |
| Project C | 98 |
If Table 1 is on the many side, you can use this expression to get your result
NewColumn = Table1[Hours at Completion] - RELATED(Table2[Travel Hours])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
That worked perfectly. Thanks so much!