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 ...
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.))
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.