Forum Discussion
benjamin_sasin
6 years agoResolver I
Add hours to existing column
Hi, I've got a whole sequence of steps in Power Query and already a bunch of pivot tables connected to the data. I found out that the time input is wrong and believes it's in my current time zone (bu...
- 6 years ago
You can add this step.
Replace text in "red font" with your previous step's name
= Table.TransformColumns(#"Changed Type",{"create_user_date", each _ + #duration(0,7,0,0)})
Zubair_Muhammad
6 years agoCommunity Champion
You can add this step.
Replace text in "red font" with your previous step's name
= Table.TransformColumns(#"Changed Type",{"create_user_date", each _ + #duration(0,7,0,0)})Anonymous
3 years agoNot applicable
Hi,
I can't get this to work.. It's asking for a comma after the #duration...
Any tips?
//Sigrid