Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Change date when a new custom column created

Hello every one,

 

I need your advise. 

there is a date column (Run_Date) in my query , all values are 30/6/2022. When i make a new custon column (= Table.AddColumn(#"Added Custom3", "Custom.1", each Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-DateTime.Date([Showroom_Date]))))) Run_Date become 20/6/2022.

 

Why does this happen??

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello,

     

    I had made a reference table from this table. When i transformed the reference table into regular table (dublicate it ) the problem is gone , and everything is ok . 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

    Did the runtime field calculate based on the M query DateTime LocalNow functions? If that is the case, this function will extract the current system DateTime and recalculate when the query table changes or refreshes.

    DateTime.LocalNow - PowerQuery M | Microsoft Docs

    If the above does not help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello,

       

      I had made a reference table from this table. When i transformed the reference table into regular table (dublicate it ) the problem is gone , and everything is ok .