Calculated column only runs on around 300 rows

[Christophe]

I have a simple date table:

Table: = CALENDARAUTO(10)

First column Date

Scond column calculated:  OffsetDate = DATEADD('Date Table'[Date],2,MONTH)

For some reason, only around 300 rows are calculated, the remaining rows are empty.. What am I missing?

[Greg_Deckler]

That's very strange, what happens if you just second the second column = [Date]. Just kind of curious.

[Christophe · Accepted solution]

I found my mistake, DATEADD takes a column and returns a table. It is not meant for calculation on a single date. Your comment helped me realize that the formula didn't just accept [Date] as argument.

Instead, I need to use a datetime function such as EDATE.

Side note: EDATE(12/31/2019,2) will return 2/29/2020.