Forum Discussion
Date Bug in Power BI
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
I don't seem to be able to format the date into DD/MM/YYYY format. I haven't applied any filter.
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 DateTableRegards,
Xiaoxin Sheng
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.
When exported, for these year with incorrect date, the time is shifted back by one hour. I think it might have something to do with daylight saving that started from 1972. See https://www.timeanddate.com/time/change/australia/sydney?year=1989