How to remove timezone

Question

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.

anonymous · Answer

Hi&nbsp;Macc-PA&nbsp;,
&nbsp;
Not very clear about the situation.
You may try disabling the&nbsp;auto-date-time&nbsp;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-savings/td-p/789919&nbsp;
https://community.powerbi.com/t5/Service/Handling-local-time-zone-with-Daylight-Savings-in-Power-BI/m-p/991812&nbsp;
Or share some sample data and expected result here.
&nbsp;
Best Regards,
Jay

ravi_ray_2022 · Answer

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

anonymous · Answer

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

Forum Discussion

How to remove timezone

3 Replies

Related content

remove duplicate value within a row

Date Timezone

Last Refresh Date change Timezone

Removing Duplicates

Remove trailing commas