Forum Discussion
Date data anomaly fetching from sharepoint
Hi All, So one of the requirements from the client was to fetch data from the share point and find the duration of a certain event. The problem arises when the data which was untouched and fr...
mahoneypat
Microsoft Employee
Microsoft EmployeeThe dates you are pulling from SharePoint will be UTC. You can add/subtract hours to add the appropriate offset, using #duration(0,-5,0,0) for example. If applicable, please also see this video.
(9) An easy way to handle Daylight Savings Time in Power Query - YouTube
Pat