The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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', however when I publish the report it changes the time. Does anyone know what time power BI works in, I thought it might be GMT but that doesnt line up.
Thanks in advance.
Solved! Go to Solution.
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
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
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?
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 Editor
No. of Queries duplicated for each individual time
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |