Forum Discussion

guibenassi's avatar
guibenassi
Icon for Advocate II rankAdvocate 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

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
7 years ago

You have to create a Date table. The reason they are returning blanks is the dates that are being calculated don't exist in the column you are using as your source. See this thread for a more comprehensive explanation.

 

DATEADD() isn't like an Excel function. It relies on a true Date table to work for both calculated columns and measures.

 

You could do this in Power Query though if you are insistent in not createing a date table. See the Date.AddDays() function there. However, that would create a column and still wouldn't solve your original problem of wanting this in a measure.