Forum Discussion

PBILearner2022's avatar
PBILearner2022
Helper I
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PBILearner2022 

     

    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!

PBILearner2022's avatar
PBILearner2022
Helper I
2 years ago

I tried to create a duplicate column and changed it to local time  and it didnt worked 

Eg: It should show : 02/01/2024 instead it shows 01/31/2024

 

Could you please help 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PBILearner2022 

 

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!