Forum Discussion

GCGradwell's avatar
GCGradwell
Helper I
10 years ago
Solved

Create a Calculated Column from Different Tables

Hi ,   I can’t work out how to create a calculated column using 2 columns from different tables in the formula.   I’m trying to create a calculated column ‘Z’ using a simple formula: X – Y   Co...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    GCGradwell

     

    Based on my understanding, it depends on the relationship.

     

    If 1:1, below formula should work.

    calculated column =
table1[X] - RELATED ( table2[Y] )

    If 1:many, the following formula should work.

    calculated column =
oneTable[X]
    - CALCULATE ( SUM ( manyTable[Y] ), ALLEXCEPT ( manyTable, Table10[linkedCol] ) )
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

GCGradwell

 

Based on my understanding, it depends on the relationship.

 

If 1:1, below formula should work.

calculated column =
table1[X] - RELATED ( table2[Y] )

If 1:many, the following formula should work.

calculated column =
oneTable[X]
    - CALCULATE ( SUM ( manyTable[Y] ), ALLEXCEPT ( manyTable, Table10[linkedCol] ) )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

what is the Table 10 related to?