Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 ) )