Calculated Column Across 2 Data Tables

[nickrawson]

Hi All

I'm a complete Power Bi novice, so please excuse me if this is something ridiculously obvious.

I have connected Power Bi to my database via SQL Server as a direct query. I have then got 2 data tables containing various data, im only interested in calculating the difference in days between 2 date columns, 1 is in a table titled CONTACT and the other in CONTACT TABLE 1. Is there a simple way of doing this? I have looked at merging tables but i keep getting an error due to it being a direct query.

Thanks in advance.

Nick

[v-chuncz-msft · Accepted solution]

@nickrawson,

Add the relationship and use RELATED Function and DATEDIFF Function.

[nickrawson]

Thank you so much!!

I wished i'd have asked a few days ago, would have saved me alot of stress and keyboard bashing.