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 ())