Combining Table

[ephramz]

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 otehr columns

The 4 columns listed for both table have values that corresponds to each other.

In table 2, I have this column called T1Pack.
I wish to create a new measure in Table 1 such that it have this new column T1Pack

How can I go about doing this. What is the DAX expression for this?

Help is appreciated. 

[v-rzhou-msft]

Hi @ephramz 

Your data model may be complex. Could you share a sample file with us? We need to know what your data model looks like.  You can share a screenshot with the result you want, this will make it easier for us  to understand your requirement.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shahfaisal]

From what your describing, it suonds like you need a calculated column, not a calulcated measure. 

Calculated Column: T1Pack = RELATED(Table2[T1Pack])

Calculated Measure: Just use whatever aggregation you need in the DAX expression (e.g. SUM(T1Pack))

Please note that both the approaches assume that there is relationship/join between the two tables.

[ephramz]

If you take a look at the picture below,

I have two tables, with what I described earlier.

I wish to create a measure such that it relate the values between the two table, and from the value in [T1Pack] i wish to minus the value from another measure [PBI(Average) Time]

[Shahfaisal]

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

[ephramz]

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]

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.