Forum Discussion
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 ...
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
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