Forum Discussion

NDG's avatar
NDG
Frequent Visitor
4 years ago
Solved

Measure to calculate days difference between dates

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

Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    NDG Sometimes simple subtraction is better:

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

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    NDG Sometimes simple subtraction is better:

    SUMX (Backlog, (Backlog [Requested Ship Date] - Backlog [Scheduled Ship Date]) * 1.))
    • NDG's avatar
      NDG
      Frequent Visitor
      4 years ago

      Thanks!! Works fine. 

  • shugh's avatar
    shugh
    Frequent Visitor
    4 years ago

    Try this:

     

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

  • shugh's avatar
    shugh
    Frequent Visitor
    4 years ago

    Apologies syntax was wrong:

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