Calculated column based on two different Tables

[ashutosh]

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.

[Eric_Zhang]

---

@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]))

[ashutosh]

@Greg_Deckler Please help me in here. Thanks in advance 🙂