Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
30rakesh
Regular Visitor

Get Current UTC datetime

Hi,

 

Can anyone please suggest me on how to get the current datetime in UTC. I used function Now() but it is returning the current system local time.

 

Thanks

Rakesh

3 REPLIES 3
elliotdixon
Responsive Resident
Responsive Resident

Hi @30rakesh I use a slightly different formula to @Greg_Deckler

 

Find your timezone e.g. mine is New Zealand +13hours for summer time.

and use code

 

Date NZTimeZone_NowDateTime = NOW()+(13/24)

unfortunatley I have to remember to change this back after daylight savings time.

SabineOussi
Skilled Sharer
Skilled Sharer

Hi rakesh,

 

I am not aware of a way to do it in DAX, but you can do it in M by going to edit queries and adding a custom column with the formula: DateTimeZone.UtcNow()

 

If you still want do it in DAX and use it as a measure, you can get your current timezone by using Now() and adding or substrating hours in order to get UTC time.

 

Hope this helps!

 

To subtract 1 hour from NOW, you can use a formula like:

 

Column = NOW() - 0.04166666666666667

For 2 hours:

Column = NOW() - 0.04166666666666667*2

etc.

 

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Kudoed Authors