How to subtract days from a date using Date.AddDays?

Question

Hello,

I am using Date.AddDays in mquery and I am receiving errors in some rows. I want to find a date of birth from the "File_Date" column minus the "Age" column. Anyone know what the problem is? Thank you!

= Table.AddColumn(#"Added Custom", "DOB", each Date.AddDays([File_Date], -([Age]*365.25)))

Answer 1

Try using Date.AddYears instead.