S:\ABL\Power BI\POC-Mi9\UTC to Local Time Sample Data.xlsx|||`Sheet1$`
False
1
UTC to Local Time Sample Data.xlsx
Table=`Sheet1$`
2020
2020-03-08
2020-11-01
2021
2021-03-14
2021-11-07
2022
2022-03-13
2022-11-06
2023
2023-03-12
2023-11-05
1-6
OrderYear = ToNumber(left([Order Time (UTC)],4))
OrderHourUTC = ToNumber(left(ri...
[DaylightSaving] = "Y"
Simple
=
DaylightSaving
True
fixed
2020-07-15 16:34:45
0
Y
2020-07-15 16:34:45
2020-07-15 16:34:45
[DaylightSaving] = "Y"
3
E
-5
Y
1
C
-6
Y
2
C
-6
N
[DSTStart] AND
[Order Date] < [DSTEnd]
]]>
Custom
=
True
fixed
2020-07-15 16:39:06
0
2020-07-15 16:39:06
2020-07-15 16:39:06
DST?
[DSTStart] AND
[Order Date] < [DSTEnd]
]]>
DST Adjustment
Warning
All
ByName
OrderHourFinal = IF isNull([OrderHourLocalDST]) then [OrderHourLocal] ELSE [Orde...
Horizontal
Sample UTC to Local