Forum Discussion

Tango2310's avatar
Tango2310
Icon for Helper I rankHelper I
2 years ago

Convert column from etc to local timezone in Get Data Process

Hi, I am performing the get data process from Dataverse and wondering how to convert to UTC+10? I was thinking it should be done at the ingestion level without having to create a measue. Ive tried...
Need Help
Tango2310's avatar
Tango2310
Icon for Helper I rankHelper I
2 years ago

This is my latest attempt 

= Table.TransformColumnTypes(#"Filtered Rows",{{"utit_quotefinaliseddate", type DateTime.AddZone(["utit_quotefinaliseddate"],10)}}))