Adding DateTime.Local() as an imported datetime column

Question

Hello,&nbsp;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.&nbsp;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:&nbsp;Table.AddColumn(#"Removed&nbsp;columns",&nbsp;"Custom",&nbsp;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 Answer

It's close.&nbsp; It needs an "each" before DateTime.LocalNow
&nbsp;
Did you type this in the advanced editor? If you use the 'Add Column' in the interface, it adds it for you

Forum Discussion

Adding DateTime.Local() as an imported datetime column

2 Replies

Related content

import datetime

Converting Epoch Datetime into regular datetime format

Convert DateTime to Date

MAX datetime truncates to date???

datetime difference in datetime format