Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Proud to be a Datanaut!
Private message me for consulting or training needs.
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
Proud to be a Datanaut!
Private message me for consulting or training needs.
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.
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
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.