Using DATEDIFF Between 2 Tables with an Inactive Relationship

[vha_labo]

Hello,
Attempting to create a column in table 02_referrals that calculates the difference between two dates from two tables with an inactive relationship.   Image notes the relationships I've got currently.

Ultimately, trying to do the equivalent of:

m_DateDiff_0102 = DATEDIFF('01_consults'[date01_consult_created], '02_referrals'[date02_referral_created], DAY) 

RELATED doesn't work due to the inactive relationship.  I was looking into using USERELATIONSHIP, but not sure if this is the right track or not (or how to do it, if correct).

Any thoughts on how to accomplish would be appreciated. Thanks.

[amitchandak]

To have a date diff between two tables. You either need to copy the date from one table to another or you can create a measure that needs to have some group level.

Refer to this : https://www.dropbox.com/s/y47ah38sr157l7t/Oder_delivery.pbix?dl=0

There are four ways you can do it.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

I have used the "Way 2" formulas here and they work perfectly!  

Sean

[kentyler · Accepted solution]

have you looked at LOOKUPVALUE()

[vha_labo]

Simple solution that appears to have done the trick.  Thanks.

[ERIC_A]

please share the solution. I have a similar problem and cannot solve it. thanks!