Forum Discussion

guibenassi's avatar
guibenassi
Advocate II
7 years ago
Solved

DATEADD ERROR

I create some measures with dateadd and I suspect that are some errors on that. Then I create a calculated columm to see the DATEADD working and prove the problem. I read some comments about using ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi guibenassi ,

     

    Without an extra date table, please try below formula:

    Vcto Ajustado=DATEADD('Receber E1'[E1_BAIXA2].[DATE];-15;DAY)

    Best regards,

    Yuliana Gu

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

Hi guibenassi ,

 

Without an extra date table, please try below formula:

Vcto Ajustado=DATEADD('Receber E1'[E1_BAIXA2].[DATE];-15;DAY)

Best regards,

Yuliana Gu

  • edhans's avatar
    edhans
    Community Champion
    7 years ago
    v-yulgu-msft wrote:

    Hi guibenassi ,

     

    Without an extra date table, please try below formula:

    Vcto Ajustado=DATEADD('Receber E1'[E1_BAIXA2].[DATE];-15;DAY)

    Yes, that will work but note that you must have AutoDate features enabled for this to work. Something I didn't think about because I always have it disabled. :smileyhappy: