Forum Discussion

Jcolvile's avatar
Jcolvile
Frequent Visitor
9 years ago
Solved

Current time + current times around the world

I need to display the current time at 4 different locations as in the image below: I can get this to work using a 'Now()' function for Brisane and then using the method of  'Now() - 1/24', how...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi Jcolvile

     

    PowerBI works in local time.

     

    For creating different times in your dasshboards,

     

    You should create a 4 different Queries and use the below syntex to get GMT time

     

    = DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-2))

     

    Change the last part of the Query, depending upon what you want in each of these queries and you will get expected results.

     

     

     

    For Chicago Time

    = DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-8))

     

    For New Zealand Time

    = DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),9))

    For Brisbane Time

    = DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),11))

     

    and so on...

     

    Refresh the Queries to get the latest time

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Hi Jcolvile

 

PowerBI works in local time.

 

For creating different times in your dasshboards,

 

You should create a 4 different Queries and use the below syntex to get GMT time

 

= DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-2))

 

Change the last part of the Query, depending upon what you want in each of these queries and you will get expected results.

 

 

 

For Chicago Time

= DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-8))

 

For New Zealand Time

= DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),9))

For Brisbane Time

= DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),11))

 

and so on...

 

Refresh the Queries to get the latest time

 

  • Jcolvile's avatar
    Jcolvile
    Frequent Visitor
    9 years ago

    Thanks BhaveshPatel, however I am just trying to work out where you put these formuals. I was originally creating them in new coloumns however that syntax doesn't work there. Would I be able to trouble you to work out where you are entering these formulas in?

    • BhaveshPatel's avatar
      BhaveshPatel
      Icon for Super User rankSuper User
      9 years ago

      In the Query Editor, Blank Query

      Go to the Advanced Editor, and Type in the code as shown in the screenshot ( Case Sensitive)

      for each individual time, Right click the Query and create duplicate, Change the Syntex as per the time expected of other region.

      See the attached Screenshot.

       

      Advanced EditorNo. of Queries duplicated for each individual time

      • Jcolvile's avatar
        Jcolvile
        Frequent Visitor
        9 years ago

        BhaveshPatel

        Thank you so much for your assistance!