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 30 Sep 1978 respectively.  I don't seem to be able to insert images.

 

Our company has contacted Microsoft for this bug. They accepted this bug and fixed in the May 2018 release of the Power BI Desktop. 

General Comment

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Pipi9,

     

    I can't reproduce your scenario, I try to filter on oct 1st without similar issue.

     

    Please provide more detail content to help us clarify this issue.

     

    E.g.

    Desktop version, filter options and formula, relationship, sample data, pbix file, screenshots...

     

    Regards,

    Xiaoxin Sheng

     

     

    • Pipi9's avatar
      Pipi9
      Frequent Visitor
      8 years ago

      Can you please run this code then drag the date into a table visual? Also I am in Australia.

       

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

       

    • Pipi9's avatar
      Pipi9
      Frequent Visitor
      8 years ago

      I don't seem to be able to format the date into DD/MM/YYYY format. I haven't applied any filter.

      • 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