Forum Discussion
Combining Table
I have two tables 1) Table 1 Column name: (Strategy), (Repair Scheme), (Engine Type), (Package), and otehr columns 2)Table 2: Column name: (Strategy), (FRS), (EngType), (Package Code), and oteh...
[PBI(Average) Time] is a measure and T1Pack looks like a column with text values. How do you intend to do the subtraction?
Table ENGG VW_TRM and Table TRM Tk1 Pack CTL#7 have related columns (Strategy), (Repair Scheme) , (Engine Type) and (Package). Table TRM Tk1 Pack CTL #7 has the column named (T1Pack) which has the values I want.
As my previous measures are based off the columns in ENGG VW_TRM table, I wish to create a measure to grab the values in TRM Tk1 Pack CTL #7 table by cross-checking the related columns and then use that data to minus off the values in the measure [Average Time] to get the calculations.