Forum Discussion
Conversion UTC to local time date
Hi, I am not able to convert UTC time to local time in a dataflow. I can convert UTC to local time in PBIX file. Has anybody solved this problem. I am beginning to think the using local in the da...
After testing many options all day, I ended up creating a custom column and adding 10 hours to the UTC. The 10 hours is the time different. Basically a manual calculation instead of relying on Power BI Dataflow to do the converstion. I ignored daylights saving. I hour difference is Immaterial in this instance.
yep - thats pretty much what mine is. in most cases the utcoffset in mins is 600