DateAdd function not adding years

[mgobble]

I am taking a date in column A and adding 2 years in column B. However, many of the cells are not producing a date. I have tried numerous formulas with little to no success. Why is this happening.

I have tried:

Column B=DateAdd('Table'[column A],2,year)

This will calculate some but not all.

I have tried:

Column B='Table'[column A]+750

This calculates 750 days (365 x 2) and all cells show a date, but i'm looking for exactly 2 years, not 750 days

[GilbertQ]

Hi @mgobble 

Could it be that [Column A] does not have a valid date?

[mgobble]

Unfortunately, all cells that contain a date are formatted the same. As I said the formula will work if I add 730 days it works fine, but when I try and add years, the formula does not populate in all the cells. 

[GilbertQ]

Hi @mgobble 

Why not just add the dates in Power Query?

I would recommend it this way, it enables better compression. And also it is a lot easier to do this in Power Query?