Skip to main content

Power BI

Merged

Function that converts PowerBI sourced UTC time to local system time in report card

Vote (7) Share
Ross Chevalier's profile image

Ross Chevalier on 22 Jul 2021 16:04:27

We need to show the last synced date and time on reports.  I have a method that returns the last sync time.  While it initially displays my local time, in short order it changes that to show the sync time in the UTC zone.  This is working as expected according to my research.



What I am seeking is a way to take the time returned by a PowerBI query which is UTC and read the local time zone from the user's machine and then apply the adjustment to a new quick measure to show the user local time.



I am not a DAX coder and my attempts to do this have failed.  Basic time math works, but I am insufficiently skilled to figure this out and I need it on a number of reports so a function or standard calculation would be superior.



Thank you