Forum Discussion

ElizabethTachji's avatar
ElizabethTachji
Icon for Helper III rankHelper III
6 years ago

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...
Dataflow
ElizabethTachji's avatar
ElizabethTachji
Icon for Helper III rankHelper III
6 years ago

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.  

 

 

frano72's avatar
frano72
Icon for Helper IV rankHelper IV
6 years ago

yep - thats pretty much what mine is.  in most cases the utcoffset in mins is 600