Forum Discussion

CmdrKeene's avatar
CmdrKeene
Helper IV
6 years ago
Solved

Adjusting SharePoint Created/Modiifed Timestamp columns for TimeZone

I've got a PowerBI dashboard that is built primarily from a SharePoint list data.   I noticed yesterday I had neglected to account for time zone differences.  A list item was modifed yesterday at 8...
General Comment
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi CmdrKeene 

    Please refer to: https://radacad.com/solving-dax-time-zone-issue-in-power-bi

     

    For example, my local time is 2020/2/12 2:55 pm, using DAX:  Now(),

    it generate time 2020/2/12 2:55 pm on Power bi Desktop report, but it shows 2020/2/12 6:55 am on Power BI Service report.

    My local timezone is +8 for UTC time.

     

    Use dax: 

    Measure 2 = NOW()+8/24

    or power query

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),8,0)

    finally it shows 2020/2/12 2:55 pm on Power BI Service.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi CmdrKeene 

Please refer to: https://radacad.com/solving-dax-time-zone-issue-in-power-bi

 

For example, my local time is 2020/2/12 2:55 pm, using DAX:  Now(),

it generate time 2020/2/12 2:55 pm on Power bi Desktop report, but it shows 2020/2/12 6:55 am on Power BI Service report.

My local timezone is +8 for UTC time.

 

Use dax: 

Measure 2 = NOW()+8/24

or power query

DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),8,0)

finally it shows 2020/2/12 2:55 pm on Power BI Service.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

  • CmdrKeene's avatar
    CmdrKeene
    Helper IV
    6 years ago

    Thanks! I'm going to research the DateTimezone.SwitchZone() function and see about working this into my powerQuery steps.

     

  • CmdrKeene's avatar
    CmdrKeene
    Helper IV
    6 years ago

    Thanks again, I believe I successfully accomplished this!  Appreciate your help.