Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.