Dateadd does not work for dates out to 2020

[jmdesigns]

Hello,

I'm trying to use a dateadd function and for any cell in the table that should show a date in 2020 shows a blank when adding 6 months to a date in July 2019. Is this a bug or another way for me to get around this?

[Seward12533 · Accepted solution]

Then you need to have a date table and link it to you data, display the date form the date table and ensure the date table extends to the cover the latest dates you want to display. 

[v-yuezhe-msft · Accepted solution]

@jmdesigns,

Please check my reply in the following similar thread.

http://community.powerbi.com/t5/Issues/Date-Table-cannot-calculate-a-date-outside-of-the-table-range...

Regards,
Lydia

[Seward12533]

Does your date table extend into 2020 and beyond? 

[jmdesigns]

The dates listed in the specific date column it is using only goes into 2019.

[Seward12533 · Accepted solution]

Then you need to have a date table and link it to you data, display the date form the date table and ensure the date table extends to the cover the latest dates you want to display.