DAX Function Guide

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.

• 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.