- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
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 ())
dax_functions_date_time.htm
Advertisements