Forum Discussion

Shard's avatar
Shard
New Member
2 years ago

Moving date depending on time (GMT to GMT-7)

Hi,   So the exciting issue i have is that we download sales data from a system based in Arazona but operate in the UK, the team who want the reports are based in Arazona so want the daily / weekly...
Need Help
dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Shard, what about this?

 

Result:

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMrLQNzDSNzIwMlHSUTIysjI0VYrVQRM2MLYyMMAUNjQCC8cCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Purchase Date (UTC)" = _t, #"Purchase Time" = _t]),
    #"Ad_PurchaseDateTimeUtc-7" = 
          Table.AddColumn(Source, "Purchase DateTime (UTC-7)", each DateTime.From(
               DateTime.AddZone(
                    Date.From([#"Purchase Date (UTC)"], "en-GB") & Time.From([Purchase Time], "en-GB"),
                    8
               )
          ), type datetime
     )
in
    #"Ad_PurchaseDateTimeUtc-7"