Measure to calculate days difference between dates

[NDG]

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

[Greg_Deckler · Accepted solution]

@NDG Sometimes simple subtraction is better:

SUMX (Backlog, (Backlog [Requested Ship Date] - Backlog [Scheduled Ship Date]) * 1.))

[NDG]

Thanks!! Works fine. 

[shugh]

Apologies syntax was wrong:

DATEDIFF ( SELECTEDVALUE ( Backlog [Requested Ship Date] ), SELECTEDVALUE ( Backlog [Scheduled Ship Date] ), DAY )

[shugh]

Try this:

DATEDIFF ( SELECTEDVALUE ( Backlog [Requested Ship Date] ), SELECTEDVALUE ( Backlog [Scheduled Ship Date], DAY ) )