Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good day,
How to calculate with Measure only lead time between dates in days.
Tried with
SUMX (Backlog, DATEDIFF (Backlog [Requested Ship Date], Backlog [Scheduled Ship Date], DAY))
The issue is that in this case, the Requested ship date can be equal to or earlier than the Scheduled Ship date.
Thanks
Solved! Go to Solution.
@NDG Sometimes simple subtraction is better:
SUMX (Backlog, (Backlog [Requested Ship Date] - Backlog [Scheduled Ship Date]) * 1.))
@NDG Sometimes simple subtraction is better:
SUMX (Backlog, (Backlog [Requested Ship Date] - Backlog [Scheduled Ship Date]) * 1.))
Thanks!! Works fine.
Apologies syntax was wrong:
DATEDIFF ( SELECTEDVALUE ( Backlog [Requested Ship Date] ), SELECTEDVALUE ( Backlog [Scheduled Ship Date] ), DAY )
Try this:
DATEDIFF ( SELECTEDVALUE ( Backlog [Requested Ship Date] ), SELECTEDVALUE ( Backlog [Scheduled Ship Date], DAY ) )