DATEADD function not returning row values more then 10 rows

[n2p2gupta]

DATEADD function not returning all the row under "column". Please help. Thanks.

[Reid_Havens · Accepted solution]

Hi there,

Happy to help. This is super curious...it should definitely return the value for ALL rows. However there is another way to write the formula. This one below should work.

Column = Table1[Date] + 5

Reid Havens - Principal Consultant

PowerPivotPro

[Eric_Zhang]

@n2p2gupta

The documentation says this behavior is by design.

---

 The result table includes only dates that exist in the dates column.

So when adding 5 days to “May 31,2017", it is "Jun 5, 2017" which doesn't exist in the date column.

You'll use @Reid_Havens suggestion as a workaround.

[n2p2gupta · Accepted solution]

Thanks Eric!

[Reid_Havens · Accepted solution]

Hi there,

Happy to help. This is super curious...it should definitely return the value for ALL rows. However there is another way to write the formula. This one below should work.

Column = Table1[Date] + 5

Reid Havens - Principal Consultant

PowerPivotPro

[n2p2gupta]

Thanks Reid!