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

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Islam 

 

Power Query is designed to extract the data from different data sources, not to record or collect data therefore your best option would be to create the datestamp at the source.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn


 

Islam's avatar
Islam
Helper V
6 years ago

thx Mariusz 

thanks for that bro but i was wondering if there is any reference for that topic and how to apply it