Forum Discussion

ephramz's avatar
ephramz
Icon for Helper II rankHelper II
4 years ago

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...
Need Help
ephramz's avatar
ephramz
Icon for Helper II rankHelper II
4 years ago

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.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

It would be much easier if you posted sample data (not images) from both tables. You can create the data in Excel and just paste it in you post.