Date error due to time zone difference

Hi nikhil0511 ,

To my knowledge, currently all the servers for Power BI are set in the UTC Timezone

You can use DateTime.AddZone function to achieve your requirement. This function adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value.

DateTime.AddZone([Date],-12)

Here is a related blog post : Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & T...

Similar threads:

https://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/m-p/153663

https://community.powerbi.com/t5/Desktop/Issue-with-Timezone-Conversion/m-p/1852857

https://community.powerbi.com/t5/Desktop/TimeZone-problems/m-p/171245

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