Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
n2p2gupta
Frequent Visitor

DATEADD function not returning row values more then 10 rows

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

 

 

 

2 ACCEPTED SOLUTIONS

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

View solution in original post

4 REPLIES 4
Eric_Zhang
Employee
Employee

@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.

Thanks Eric!

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

Thanks Reid!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.