Forum Discussion

Pipi9's avatar
Pipi9
Frequent Visitor
8 years ago

Date Bug in Power BI

Hi,   I have noticed a date bug in Power BI Desktop. PowerBI desktop display 1st of Oct incorrectly for certain years.     1 Oct 1972 and 1 Oct 1978 are displayed and exported as 30 Sep 1972 and ...
General Comment
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Pipi9,

 

You can try to use below formula to generate calendar table.

let
    DateList = List.Dates(#date(1970, 1, 1), Duration.TotalDays(Date.From(Date.EndOfYear(DateTime.LocalNow()))-#date(1970,1,1)), #duration(1, 0, 0, 0)),
    AddColumns = List.Transform(DateList, each {_}),
    DateTable = #table(type table[Date=date], AddColumns)
in
    DateTable

 

Regards,

Xiaoxin Sheng

Pipi9's avatar
Pipi9
Frequent Visitor
8 years ago

I think this issue specifically impacts on the first Sunday in October in years later than 1972, the year the daylight saving was introduced for time zone ‘(UTC+10:00) Canberra, Melbourne, Sydney’ if automatic adjustments for daylight saving is turned on.

 

This is clearly related to the daylight saving adjustments applied by Microsoft Windows for time zone ‘(UTC+10:00) Canberra, Melbourne, Sydney’ as the problem is not present for other time zones or if auto adjustment is turned off.   

 

Rules applied by Microsoft are not correct as the daylight saving in this time zone used to start on the last Sunday in Oct prior to 2008 (not first Sunday in Oct as of now) and it should starts at 2:00 am not 12:00am.