Adding DateTime.Local() as an imported datetime column

[Anonymous]

Hello,

I am trying to add an imported date column during the Power Query step of my dataflow. I have an inserted timestamp for the source, however that timestamp can change. I am trying to utilize the incremental refresh capabilities of Dataflows and advice from Microsoft is that if one wants to use the (Detect Max Data Changes) option, I would need a DateTime column that would not change.

This led to me trying to create the DateTime column in Power Query. I cannot use DAX since DAX is not allowed at this step of the Dataflow process.

I tried adding a custom column (seen below) but am getting this error: 

Table.AddColumn(#"Removed columns", "Custom", DateTime.LocalNow())
We cannot convert the value #datetime(2020, 2, 27, 11, 39, 28.9966141) to type Function.

Any help on this would be greatly appreciated.

Thank you!

[HotChilli · Accepted solution]

It's close.  It needs an "each" before DateTime.LocalNow

Did you type this in the advanced editor? If you use the 'Add Column' in the interface, it adds it for you

[Anonymous]

Thank you @HotChilli it worked.

To your later question, yes I started with adding a conditional column then edited it in the advanced editor. I was unable to find the add new column in the interface. could you point me to where it is?