topic DATEADD function not returning row values more then 10 rows in Developer

DATEADD function not returning row values more then 10 rows

n2p2gupta — Fri, 09 Jun 2017 14:30:23 GMT

Re: DATEADD function not returning row values more then 10 rows

Reid_Havens — Fri, 09 Jun 2017 22:47:40 GMT

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

Re: DATEADD function not returning row values more then 10 rows

Eric_Zhang — Mon, 12 Jun 2017 03:09:29 GMT

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.

Re: DATEADD function not returning row values more then 10 rows

n2p2gupta — Mon, 12 Jun 2017 23:17:51 GMT

Thanks Reid!

Re: DATEADD function not returning row values more then 10 rows

n2p2gupta — Mon, 12 Jun 2017 23:18:33 GMT

Thanks Eric!