Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the current date and time in datetime format.
The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
Syntax
NOW()
Return value
A date (datetime).
Remarks
The result of the
NOWfunction 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
NOWfunction is always in the UTC timezone.The
TODAYfunction 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.
Example
The following example returns the current date and time plus 3.5 days:
= NOW()+3.5