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.