Forum Discussion
Adding DateTime.Local() as an imported datetime column
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 utiliz...
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
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
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?