DAX Date & Time - NOW function

Description

Returns the current date and time in datetime format.

Syntax

NOW () 

Parameters

No parameters for this function.

Return Value

A date in datetime format.

Remarks

DAX 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 workbook.

DAX uses datetime format when working with dates. Dates stored in other formats are converted implicitly.

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

DAX TODAY function also returns the current 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

= NOW () 
= HOUR (NOW ())