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.
Hi All,
I have designed a dashboard, which having the DateTime column as ReadyBy which is in UTC timezone, and I need to convert this to local timezone depend on the stores available in that timezone.
I have used following link for reference https://community.powerbi.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-sa...
It works for me(For specific timezone), but I having multiple timezones available in my database as below:
It works for some stores but not works for other stores.
So Please help me to fix this.
Solved! Go to Solution.
Hello @Anonymous ,
If I understand your requirements correctly, there is a solution in this forum: Convert-UTC-to-client-time-zones.
You will need to use DateTimeZone.SwitchZone function.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Hello @Anonymous ,
If I understand your requirements correctly, there is a solution in this forum: Convert-UTC-to-client-time-zones.
You will need to use DateTimeZone.SwitchZone function.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
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.