Forum Discussion
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 create a new column, based from Date+Index, and then delete the first two, but it's a waste of processing.
I have already this formula:
= Table.TransformColumns(#"ChangeDate",{{"DataDoc", each (Date.AddMonths([DataDoc],each [Index])) }})
but it gives me this error:
Expression.Error: We cannot apply field access to the type Date.
Help...
2 Replies
- ImkeFCommunity Champion
- MClerigoNew Member
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!