Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have an hours tracking report which includes clock in and clock out dates and times . I've programed the datetimes in Central Time using DateTime.AddZone([Clock In],-2) in Power Query. My report refreshed normally in Desktop, but after I publish to Service and refresh the data, the clock in and out times show in UTC. I need my report to be in Central Time and refreshed regularly. Any suggestions?
Solved! Go to Solution.
You need to use the DateTimeZone.SwitchZone function DateTimeZone.SwitchZone - PowerQuery M | Microsoft Docs
So DateTimeZone.SwitchZone([Clock In], -6) (If you are referring to Central TZ in the use, but it is -5 right now. See this blog article on handling daylight savings when doing this sort of thing. Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou need to use the DateTimeZone.SwitchZone function DateTimeZone.SwitchZone - PowerQuery M | Microsoft Docs
So DateTimeZone.SwitchZone([Clock In], -6) (If you are referring to Central TZ in the use, but it is -5 right now. See this blog article on handling daylight savings when doing this sort of thing. Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting