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...
Hi, ElizabethTachji
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch server’s date/time.
You may modify the datetime by DAX or Power Query as below.
DAX:
LocalDatetime = Table[UTC Datetime]-7/24
Power Query:
Custom column = DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-7,0)
For further information, you refer the following links.
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.