Forum Discussion

Islam's avatar
Islam
Helper V
6 years ago
Solved

Asking About Date Function

Hey Experts i have added a column to my query and add this step targeting type the date and time once a value is entered in items column, here is the formula: #"Added Custom" = Table.AddColumn(#"Ch...
Need Help
  • Islam's avatar
    Islam
    6 years ago

    hi v-juanli-msft  

    thx man for help i just figured out that i can't enter the date only once when i enter data in a specified column like in excel built in function on VBA

Islam's avatar
Islam
Helper V
6 years ago

hi v-juanli-msft  

thx man for help i just figured out that i can't enter the date only once when i enter data in a specified column like in excel built in function on VBA

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Islam ,

 

I have marked your reply as a solution, however, this is not precisely correct.

There is a workaround to achieve what you want using "incremental refreshes" - this should also work in Excel.

If you use this technique to preserve the existing data and only overlay changes the original date-time stamp will withstand consequent refreshes. 

 

Kind regards,

JB