Column calculation in Query Editor

[M-M-P]

Hi everyone

In the Query Editor I have a column with Timestamps and in another column I have a number.

See the picture below.

That number is the hour offset I want to plus into the timestamp. 

The result should look like this:

I can create a new column where I do the calculation with this command = [Timestamp] + #duration (0, [Hours Offset], 0.0)

But is it possible to do the calculation in the original column?

Thanks in advance

[OwenAuger · Accepted solution]

Hi @M-M-P 

Credit to @ImkeF for this method using Table.ReplaceValue (post here)

Rather than adding a new column, put this in the formula bar (where PreviousStep is the name of your previous query step):

= Table.ReplaceValue(PreviousStep, each [Timestamp], each [Timestamp]+#duration(0,[Hours Offset],0,0), Replacer.ReplaceValue, {"Timestamp"})

This has the side-effect of discarding the column type of Timestamp.

To avoid losing the column type, you can use this code instead:

= Value.ReplaceType(Table.ReplaceValue(PreviousStep, each [Timestamp], each [Timestamp]+#duration(0,[Hours Offset],0,0), Replacer.ReplaceValue, {"Timestamp"}), Value.Type(PreviousStep))

Regards,

Owen

[M-M-P]

@OwenAuger 
Thanks a lot, it does exactly what I wanted 😄