Forum Discussion
Userelationship
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.
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
amitchandak Appreciate that file. However, none of those methods solve my issue.
I am specifically needing to use USERELATIONSHIP in order to get both the Due Date field (active), and the Date Shipped field (inactive) to respond to the date table.
The issue as stated below is that I do not get the option (no intellisense) to use my Orders(due date) field. It just does not come up as an option when writing the measure. I'm guessing it has something to do with the fact that it is the active relationship field.