Convert Date modified to local timezone

[Anonymous]

Hello,

I want to get the modified date and time of an Excel file stored in a SharePoint folder. I was able to do it via Power Query but the problem is the modified date and time are always shown as UTC, and i want to convert it to Western Europe time which is currently UTC+1 in winter and in summer, it is UTC+2 due to DST. Is that possible?

Currently, this is what i see in Power Query:

If i select the Date/Time/Timezone:

I get this:

But will the time automatically adjust for summer due to DST? And is the time shown dependent on the configuration settings of the user's browser, etc?

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You may refer to this blog:

Using Power BI to ensure Daylight Savings Dates and Times change dynamically - FourMoo | Power BI | Data Analytics

There's a way to easily manage Dates and times for Daylight savings. 

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.