Forum Discussion
Solved
DAX dateadd function cannot add 100 days
Dateadd seems can't add more than 100 days to a given date. What is wrong?
t. Thank you, both
5 Replies
DATEADD will only return dates if those dates are in your date table.
DATEADD - Microsoft LearnI generated a list of 110 dates and added a column to add 100 days to each. You will see only the first 10 days return a value.
Is there data in the calendar table after April 10, 2024?
t. Thank you, both
