How to remove timezone

[Macc-PA]

Hi,

I get my data from an odata feed where the dates come down in UTC plus an offset which includes daylight saving, E.g 21/05/2022 00:00:00 +1 for a date in the UK timezone with daylight saving.

However, all my dates are already in the correct timezone including the daylightsaving. In PBI the dates get changed to include daylight saving which gives incorrect results for the analysis, eg 21/05/2022 00:00:00 +1 is displayed as 20/05/2022.

[omnepresent]

Ans- syntax-DateTimeZone.RemoveZone(dateTimeZone as nullable datetimezone) as nullable datetime

[ravi_ray_2022]

syntax-DateTimeZone.RemoveZone(dateTimeZone as nullable datetimezone) as nullable datetime

[Anonymous]

Hi @Macc-PA ,

Not very clear about the situation.

You may try disabling the auto-date-time feature and check again.

If it doesn't work, you may take a look at these topics.

https://community.powerbi.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-sa... 

https://community.powerbi.com/t5/Service/Handling-local-time-zone-with-Daylight-Savings-in-Power-BI/... 

Or share some sample data and expected result here.

Best Regards,

Jay