NOW

NOW is a DAX function that returns the current date and time in datetime format.

Syntax

NOW( )

Return Values

A date (datetime).

Remarks

• The result of the NOW function changes only when the column that contains the formula is refreshed. It is not updated continuously.

• In the Power BI Service, the result of the NOW function is always in the UTC timezone.

• The TODAY function returns the same date but is not precise with regard to time; the time returned is always 12:00:00 AM and only the date is updated.

The following example returns the current date and time plus 3.5 days:

= NOW()+3.5

Related functions

Other functions related to NOW are:

• TODAY
• UTCNOW
• UTCTODAY

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/now-function-dax