Forum Discussion
Solved
Date value difference between SharePoint and Powerbi
Hi all, I've pulling data from a Sharepoint list, but the date values in PowerBi are off by 1 day. For example, I have a datecompleted of 01/02/2024 in my Sharepoint list, but in PowerBi it shows...
Assume that you are using UTC+8 locale datetimes, add a custom column with below code (change 8 according to your locale).
DateTimeZone.SwitchZone(DateTime.AddZone([Date], 0), 8)
Then change this column to DateTime or Date data type per your need.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
You can use Table.TransformColumns for each columns you needed.
Adple