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.
Created a report in Desktop. The date column being brought in is in UTC +0. Using that as a base column the following additional columns are created:
= Table.AddColumn(#"Renamed Columns1", "Created Date UTC", each DateTime.AddZone([Created Date],0))
= Table.AddColumn(#"Reordered Columns", "Created Date UTC - 7", each DateTimeZone.SwitchZone([#"Created Date UTC"], -7))
Change Types Applied:
= Table.TransformColumnTypes(#"Reordered Columns1",{{"Created Date UTC", type datetimezone}, {"Created Date UTC - 7", type datetimezone}})
= Table.TransformColumnTypes(#"Changed Type",{{"Created Date UTC - 7", type date}})
Publish Report, and the following occurs:
L/H Side is Desktop. R/H side is report published to Service.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.