Forum Discussion

vincenardo's avatar
vincenardo
Icon for Helper I rankHelper I
5 years ago

Convert Date Time in UTC to PST

I have a date / time field coming in from a connection to Salesforce. The date/time is stored in UTC and I need to transform it to PST (our local time).   I tried to edit the query and 'transform' ...
Need Help
vincenardo's avatar
vincenardo
Icon for Helper I rankHelper I
5 years ago

I recieved this error; ??

Expression.Error: A cyclic reference was encountered during evaluation

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ok, your last step name is #"Reordered Columns1", so:

 

= Table.TransformColumns(#"Reordered Columns1", {{"AbsentStart", DateTimeZone .ToLocal}, {"AbsentEnd", DateTimeZone.ToLocal}})