Forum Discussion
Anonymous
6 years agoNot applicable
Userelationship
Hello - I am trying to use userelationship to connect an inactive field. Ultimately I want to determine the days difference between when orders were due, and when they shipped. I have two...
- 6 years ago
Anonymous , Both date are from the same table. So you do not need userelation for date diff.
In a new column = datediff(order[due Date], order[Shipped Date],DAY)
In a new measure= datediff(min(order[due Date]), Max(order[Shipped Date]),DAY) // Refer my blog for row context
Now use relation is which date you want to use when you display this. So on top of this formula, you can use one of the date.
Or can have two formula one for each date.
amitchandak
6 years agoSuper User
Anonymous , Date diff refer to this blog
Or this file, depending on where two dates are there are 4-5 method
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0