Forum Discussion

osinquinvdm's avatar
osinquinvdm
Advocate II
9 years ago
Solved

How come the value is sometimes not calculated

I have a creation date and a delay. I'm calculating the due date by adding the delay to the creation date   Date due = DATEADD([Date created];[Delay];DAY) in 80% of the cases it works fine but fo...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi osinquinvdm,

     

    Please modify your formula as below, this will give all the due date as expected:

    Date due = DATEADD(TableName[Date created].[Date],[Delay],DAY)

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi osinquinvdm,

 

Please modify your formula as below, this will give all the due date as expected:

Date due = DATEADD(TableName[Date created].[Date],[Delay],DAY)

 

Best regards,
Yuliana Gu