Forum Discussion

ashutosh's avatar
ashutosh
Helper I
9 years ago

Calculated column based on two different Tables

I have three tables: 

Table 1               Table 2                Table 3

 

There is relationship between Table 1 & Table 2 and Table 1 & Table 3, I am not able to make relationship between Table 2 and Table 3 because of many to many relationship. 

 

Now I want to perform a caluclated column in Table 2 which includes one column from Table 3, it's a Date difference calculation.

 

How can I do that, Related is not working here, since there is no direct relationship between Table 2 and Table 3.

Need Help
Show and Tell

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    ashutosh wrote:

    I have three tables: 

    Table 1               Table 2                Table 3

     

    There is relationship between Table 1 & Table 2 and Table 1 & Table 3, I am not able to make relationship between Table 2 and Table 3 because of many to many relationship. 

     

    Now I want to perform a caluclated column in Table 2 which includes one column from Table 3, it's a Date difference calculation.

     

    How can I do that, Related is not working here, since there is no direct relationship between Table 2 and Table 3.

    ashutosh

    Table2 and Table3 actually have relationship. Could you post more details about your those 3 tables and the expected output.

    By the way, could you try to create a calculated column in Table2 like 

    Column = CALCULATE(SUM(Table3[one column]))