Forum Discussion
Date filtering error
Hi, I have an error with the date filter for daylight saving time. If I put as start of the filter the day of the daylight saving time change (September 5) I get that filter generated by the DA...
Hi Anonymous ,
I'm using Power BI Desktop Version: 2.97.861.0 64-bit (september 2021).
In Chile we had a time change on September 5th, we moved the clocks forward 1 hour.
With this the DAX query that Power BI generates internally (I obtained this from Performance Analyzer) gives me the date filter but with 1 hour added which makes my filter does not behave as I expect.
If I put it to start on the 5th it will show me the dates from the 6th onwards.
The problem is only with this particular day for that condition, but I don't know how to fix it.
Thanks
HI Cris_Cuevas_,
Perhaps you can take a look at below blog about handle daylight saving and timezone issue if helps for your scenario:
Regards,
Xiaoxin Sheng