Datediff across two tables from different datasets

[Anonymous]

Hi there,

I need to create a column which shows the difference in months between redemption date and completion date using the inactive relationship between account details & account details 2:

I don’t seem to be able to use the CALCULATE function to use a USERELATIONSHIP function and when I’m trying to pull through columns using RELATED() I keep getting a message saying the relationship does not exist. I’m trying to create this measure in the account details 2 table.

Any ideas?

thanks

[V-lianl-msft]

The problem is not clear. Could you share pbix with these two tables after deleting sensitive data?

[amitchandak]

@Anonymous , if you want to create a column, then you do not need relationship

You can bring a column in table 1 from table 2 like 

maxx(filter(Table2, Table2[ID] = Table1[ID]), Table2[Date])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8