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 have tried your code and still failed miserablly. When I dragged the 'Date' column into a table visual, the date field was automatically changed to Date Hierarchy. However if I remove the hierarchy, it becomes incorrect.