11 Replies Latest reply on Mar 1, 2019 6:30 AM by Yuriy Fal

    Date Diff from 2 Data Sources

    Shivi Bhatia

      Hi All,


      We need to calculate the difference between 2 dates which are coming from 2 excel sheets - Forecast Date and Actual Date.


      Tried and went through other questions posted but still not able to figure out:


      Tried the calc:

      DATEDIFF('day',MAX([Forecast Date1]),(ATTR([Drawdown].[Actual Drawdown Date])))

      however this does not show the value and appear blanks.

      Have performed data blending on these variables in the data.


      Request help on this please.


      Message was edited by: Shivi Bhatia Please use this latest file.