DAX dateadd function cannot add 100 days

[kenxchen]

Dateadd seems can't add more than 100 days to a given date.  What is wrong? 

[kenxchen · Accepted solution]

t.  Thank you, both 

[kenxchen]

Got it.  Thank you both!

[danextian]

Please accept as solution the actual solution post/s.

[mickey64]

Is there data in the calendar table after April 10, 2024?

[jgeddes]

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.