Power Query - Change data

Question

Dear

I'm getting data into Power query with some dates and I need to change the dates for all rows to the current date.

I can't use Table.ReplaceValue, because it requires to type the old value explicitly, but the old date is not constant.

What's the correct function to use?

Note, I can't add a custom column, but rather I must change the existing date

Thank you

Reuven

Answer 1

Hi @Reuven Leibowitz

let  
    // Source table for demo:  
    Source = Table.FromList(  
        List.Dates(#date(2020,1,1),10,#duration(1,0,0,0)),  
        Splitter.SplitByNothing(),  
        type table [ColumnWithDates=date]  
    ),  
    AllDatesAsToday = Table.TransformColumns(Source,  
        {"ColumnWithDates", each Date.From(DateTime.LocalNow()), type date}  
    )  
in  
    AllDatesAsToday  

EDIT: I did not mention the following option as it doesn't allow keeping the types (with same Source as above):

     AllDatesAsToday = Table.ReplaceValue(Source, each [ColumnWithDates], each  
        Date.From(DateTime.LocalNow()),  
        Replacer.ReplaceValue, {"ColumnWithDates"}  
     )  

If this solves your problem please mark as answer to help others with a similar scenario - Thanks

Answer 2

Hi Lz
Your second answer is more focused on my question, as my Achilles' heel is using each and _ .
I must point out that it's very beneficiary to read your codes. I'm learning a lot from it.
If you are giving a web course I would like to join it.

Thanks
Reuven