Forum Discussion
Solved
Expression.Error: We cannot apply field access to the type Date.
Hi, I'm trying to change values in a column, based from another column. In more detail, I have a column "Date", and another column "Index". I want to add "Index" months to the "Date". I know I can c...
YEAH MAN!
Thanks very much.
Following your lead, I came up with:
= Table.ReplaceValue(#"ChangeDate",each [DataDoc],each (Date.AddMonths([DataDoc],[Index])),Replacer.ReplaceValue,{"DataDoc"})
Exactly what I was searching for. Just looking with the wrong angle.
Thanks again!