overdue in days 28 / 90 / 180 / 356 - last one doesn't work

[Mike_Mace]

I use formula

Overdue 28d = IF(DATEDIFF(DATEADD([Created].[Date], 28, DAY), TODAY(), DAY) >=0, "Yes", "No")

i repeat for 90, 180, 356 days

The overdue percentage should reduce at time increases but at 356 days the percentage increases again.

I crosschecked formula and all other percentages are correct. 356 should be 3% - anyone can say why formula is missbehaving

I've done a few trials and the formula starts to missbehave at around 295 days356days overdue wrong

[Mike_Mace · Accepted solution]

Discovered that the wrong reading appeared when the dates at DATEADD function did not exist in the dates column. I created a relationship with a Calendar date table and issue was resolved.