Forum Discussion
Timesone In Powerbi Desktop
Hi,
My requirement is to develop a Today's call count KPI.
today() function working as IST timezone.
but i require EST timezone(todays Callcount).
How can I change this one?
Hi Anonymous ,
You can use DateTimeZone.SwitchZone function to switch your table date time column [DateKey] to local time via copy and paste the code below , assuming the " 8 " is hours , and "10" is minutes ,which is the changed hours between IST timezone and EST timezone.
DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),-8 ,10)
You can learn more: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337
https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous seems like a duplicate question.
Hi Anonymous ,
You can use DateTimeZone.SwitchZone function to switch your table date time column [DateKey] to local time via copy and paste the code below , assuming the " 8 " is hours , and "10" is minutes ,which is the changed hours between IST timezone and EST timezone.
DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),-8 ,10)
You can learn more: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337
https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.
Best regards
Amy Cai
