Timesone In Powerbi Desktop

[Anonymous]

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?

[v-xicai]

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

[v-xicai · Accepted solution]

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.

[parry2k]

@Anonymous seems like a duplicate question.