Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
have you looked at LOOKUPVALUE()
Help when you know. Ask when you don't!
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
I have used the "Way 2" formulas here and they work perfectly!
Sean
have you looked at LOOKUPVALUE()
Help when you know. Ask when you don't!
Simple solution that appears to have done the trick. Thanks.
please share the solution. I have a similar problem and cannot solve it. thanks!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |