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
DATEADD will only return dates if those dates are in your date table.
DATEADD - Microsoft Learn
I 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.