Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
60 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |