Forum Discussion

ephramz's avatar
ephramz
Helper 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
Shahfaisal's avatar
Shahfaisal
Solution Sage
4 years ago

[PBI(Average) Time] is a measure and T1Pack looks like a column with text values. How do you intend to do the subtraction?

ephramz's avatar
ephramz
Helper 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
    Community 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.