Forum Discussion

AlexTi's avatar
AlexTi
New Member
3 years ago
Solved

Time Issue, Powerbi Desktop and Sharepoint

Hey,  i have the problem. The Date in my sharepoint list is not the same in the PowerBi Desktop. Maybe in Sharepointlist its 23:00 then it is in PowerBi 00:00. Its depends everytime with the UTC.  ...
Need Help
  • ChielFaber's avatar
    ChielFaber
    3 years ago

    You can use the function DateTime.AddZone.

    With the help of this function you can make a custom column that changes the UTC datetime value to your local time.

     

    Just add a custom column with DateTime.AddZone([Columname], hours, minutes)

    For example:
    DateTime.AddZone([Columname], 2, 30)

     

    this adds two hours and 30 minutes to the UTC time

     

     

ChielFaber's avatar
ChielFaber
Super User
3 years ago

You can use the function DateTime.AddZone.

With the help of this function you can make a custom column that changes the UTC datetime value to your local time.

 

Just add a custom column with DateTime.AddZone([Columname], hours, minutes)

For example:
DateTime.AddZone([Columname], 2, 30)

 

this adds two hours and 30 minutes to the UTC time