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] ) )
SiddhiDoshi's avatar
SiddhiDoshi
Frequent Visitor
4 years ago

Thank you Ashish_Mathur for the solution. It is helpful.

Just want to confirm : Are we saying we cannot use related table with multiple filter condition in CALCULATE function?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

You are welcome.  I prefer using a calculated column formula because it simplifies the measure and allows me to go back to the table and apply filters, if i ever have to.