UTCNOW Function (DAX)

How does the UTCNOW function (DAX) work?

The UTCNOW function (DAX) returns the current UTC date and time.

UTCNOW Formula Syntax

UTCNOW (
   
)

How do you use the UTCNOW function?

You can use this function whenever you need to retrieve the current time in this format. Another common use of UTCNOW is in log messages where you want to record the time at which the message was written.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the UTCNOW function

  • Always include the format, even if the value is optional. The default value is “yyyy-MM-ddTHH:mm:ss:fffffffK” but you should control what the end-user will see. You can define a single format specifier (for example “o”) or a custom format pattern (for example “yyyy-MM-dd”) so pick your favorite, but be sure to define it.
  • Since it can be confusing for the user to see the dates in UTC, you can use Flow’s “Convert Time Zone” action that will enable you to convert the date. Please use this and don’t try to do the math yourself. Otherwise, you may show invalid times to the user.

Related Video Tutorials

Formula examples using the UTCNOW function

EVALUATE { FORMAT(UTCNOW(), “General Date”) }

UTCNOW(‘yyyy-MM-ddTHH:mm:ss’)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership