topic Calculated column only runs on around 300 rows in DAX Commands and Tips

Calculated column only runs on around 300 rows

Christophe — Sat, 23 May 2020 20:41:03 GMT

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?

Re: Calculated column only runs on around 300 rows

Greg_Deckler — Sat, 23 May 2020 20:57:27 GMT

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

Re: Calculated column only runs on around 300 rows

Christophe — Sat, 23 May 2020 23:18:12 GMT

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.