Dynamic Dates on Power BI Online Service reports based on user local date timezone

[ksivaganesh99]

Hello,

I have a scenario where I want to dispaly date based on end user date timezone which I couldn't able to acheive with my understanding of DAX and Power Query. 
I have users across the globe.

Any help is highly appreciated.

[collinq]

Hi @ksivaganesh99 ,

When you say that you want to display the date, do you mean that you want the "current date" to display somewhere on the screen?  Or, are you trying to show the refresh time in the local time zone?   Here is a potential answer  https://radacad.com/solving-dax-time-zone-issue-in-power-bi   There is also this solution here:

https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[ksivaganesh99]

Hi @collinq ,

Thanks for replying. We want UTC date to be converted to respective users locale timezone and dispaly in their timezone.

Appreciate your help.

[collinq · Accepted solution]

Hey @ksivaganesh99 ,

I think the solutions shown here (about building a table and then a filter or parameter to show the user in their local time would be the way to go):

https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!