Database Reference
In-Depth Information
9. Click on the
Close & Load
button on the
Home
tab and select
Close & Load
to
save your query.
Adding functions in your query
Follow these steps to add functions to your query:
1. In the
Power Query
tab, select
From Other Sources
and click on
Blank Query
.
2. The query editor opens. Select the
View
tab and click on the
Advanced Editor
button.
3. Type the following query in the
Advanced Editor
:
(UTCTime as datetime)
=>
let
Source =
DateTimeZone.ToLocal(DateTime.AddZone(UTCTime,0))
in
Source