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 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.
6 Replies
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.
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]
[PBI(Average) Time] is a measure and T1Pack looks like a column with text values. How do you intend to do the subtraction?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
