Datediff across two tables from different datasets

Question

Hi there,&nbsp;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 &amp; account details 2:&nbsp;&nbsp;&nbsp;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?&nbsp;thanks

amitchandak · Answer

Anonymous , if you want to create a column, then you do not need relationship 
&nbsp;
You can bring a column in table 1 from table 2 like&nbsp;
&nbsp;
maxx(filter(Table2, Table2[ID] = Table1[ID]), Table2[Date])
&nbsp;
refer 4 ways to copy data from one table to anotherhttps://www.youtube.com/watch?v=Wu1mWxR23jUhttps://www.youtube.com/watch?v=czNHt7UXIe8

v-lianl-msft · Answer

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

Forum Discussion

Datediff across two tables from different datasets

2 Replies

Related content

DATEDIFF DAX

DATEDIFF Difference

Create a report per Worker ID with different datasets feeding different tablix

difference between dataflows and datasets?

Refresh dataset api