Forum Discussion
Datediff across two tables from different datasets
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: ...
amitchandak
Super User
Super UserAnonymous , 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