Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |