Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert Date Column from UTC to EST Timezone

Hi,    I'm pulling CRM dynamics data in UTC format, I see that dates showing in Powerbi is different from CRM dynamics. Now i want to convert that date column to local time zone EST.    Please sh...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    UTC is 5 hrs ahead of EST,so create below M query to convert the timezone column to EST time:

    EST = DateTimeZone.SwitchZone([UTC],-5)

    And you will see:

    For the sample .pbix file,pls see attached.

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

lmyers's avatar
lmyers
Frequent Visitor
4 years ago

I'm using the powerbi template - CQ and AA analytics combined analytics. The call queue analysis table has time in UTC. How do I add a column, conversion to conver this to EST? When filtering on the measure Calls volumne for a day, the time is in UTC which is not helpful for our staff when they are looking at what time calls are coming in.

 

I'm very new to powerbi and would like some assistance how I can add a column to this table to convert the Date column to a Date column in EST.

 

I've tried to follow these suggestions but not sure how to apply this to the template.