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
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!