Forum Discussion
Cycle Times Date Table and USERELATIONSHIP
Currently I have only 1 active relationship and about 17 other inactive DATE relationships attached to my date table. There are a lot of dates I'm working with in my dataset.
In any case, I think I am overthinking this. If all dates in my dataset have a relationship setup with Date[Date] from my date table, then I should just be able to use the endpoint (end date) of the cycle time as my relationship.
For example:
CT Order Completed - Ship =
CALCULATE(
DIVIDE(
SUM('Orders'[CycleTIme-OrderComplete_to_Ship]),
[Orders - Shipped],0
),
USERELATIONSHIP(Date[Date],'Orders'[Ship Date])
)
I was banging my head against the wall trying to organize my thought process utilizing all 3 dates... but really the endpoint date (in reference to the measure above) is my ship date. I would use the:
USERELATIONSHIP(Date[Date],'Orders'[Ship Date])
because Ship Date is my end point in the cycle time calculation, I wouldn't use Order Complete Date, or any other date (and subsequent relationships)... All I would need to do from here is throw the Date[Date] field on the X axis and let the relationship take over.
Do you agree with my thought process here... am I making any sense?