Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:

Hi krishna_murthy,

 

Try to use DateTime.From instead of DateTime.Add:

Table.AddColumn("Proofered Column", "HwDateTime", each DateTime.From([order_items]) + #duration(0,5,30,0))

 

Or even Simpler:

Table.AddColumn("Proofered Column", "HwDateTime", each [order_items] + #duration(0,5,30,0))

 

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.