Forum Discussion

MAFE62's avatar
MAFE62
Frequent Visitor
6 years ago

Date value is changed when visualized from a dataset

Hi guys, I started to learn Power BI 2 months ago. I have been solving some problems looking for solutions in this community, however currently I have the following scenario and I haven't find a sol...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
6 years ago

If I am not mistaken  PBI service is using GMT +0. I would convert Baseline Finish and Actual Finish columns to a GMT + 0 timezone then convert it to your local timezone. You can add a custom colum in Power Query using 

DateTimeZone.SwitchZone ( Datetime.AddZone ( [datetimecolumn], 0 ), yourtimezone )

 

If your colums aren't datetime, you may convert it to that format first. After adding the custom columns, you can switch the data type back to date only.

  • MAFE62's avatar
    MAFE62
    Frequent Visitor
    6 years ago

    danextian,

     

    The columns Baseline Finish and Actual Finish are datetime.

     

    My question is: The conversion occurs even when the data comes from a field in a user table?

     

    Thanks,

    Mafe62

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      6 years ago

      I'm thinking it could be because, in the backend, the database actually uses a different timezone. But once a report is exported, datetime fields are changed to the timezone of the user based on location or whatever was set by the user. I encountered this when working on Salesforce objects - time datetime info on the website and the report is different from that in the object.