World Map with Time

[mpraka]

Hi All,

Do we have any world map with Time?

Say for eg. I would like to see New York, London and Mumbai in the map and their respective time. Thank you.

Regards,

Prakash M

[v-yalanwu-msft · Accepted solution]

Hi, @mpraka ;

1.You could create a table list .

2.then in power query add custom column.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8kstV4jML8pWitWJVvLJz0vJzwMzfUtzkxIzlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Country = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Country", type text}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Time", each if [Country] = "New York" then DateTime.LocalNow() 
else if   [Country] = "London" then DateTime.AddZone(DateTime.LocalNow(),5)
else  DateTime.AddZone(DateTime.LocalNow(),10,30))
in
    #"Added Conditional Column"

3.Then add tolltip

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.