Forum Discussion

rrodillas012's avatar
rrodillas012
New Member
1 year ago
Solved

PowerBI DirectQuery, Date and Time conversion from UTC to UTC+13

Hi Good Day! 

I currently creating a dashboard on PowerBI Desktop using DirectQuery and it's connected to Dynamics365 Dataverse, I'm having a hard time figuring out how to convert the date and time from UTC to local time zone (Auckland NZ).
Table name: incident
Date column name: Created On 

I've tried modifying it thru power editor seems like it wasn't allowed in DirectQuery. 

Can someone provide some possible ways on how to convert date and time from UTC to UTC+13?

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi rrodillas012 ,
    Based on your description, you can create a measure as a reference indicator to display the time at UTC+13

    CreatedOn_UTC_Plus_13 = 
VAR CreatedOnUTC = MAX('incident'[Created On])
RETURN CreatedOnUTC + TIME(13, 0, 0)

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi rrodillas012 ,
    Based on your description, you can create a measure as a reference indicator to display the time at UTC+13

    CreatedOn_UTC_Plus_13 = 
VAR CreatedOnUTC = MAX('incident'[Created On])
RETURN CreatedOnUTC + TIME(13, 0, 0)

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Omid_Motamedise's avatar
    Omid_Motamedise
    Super User
    1 year ago

    use this formula

     

    DateTime.AddZone(DateTime.From([Created On]), 13)