DAX Date & Time - TODAY function

Description

Returns the current date.

Syntax

TODAY () 

Parameters

No parameters for this function.

Return Value

Current date in datetime format.

Remarks

DAX TODAY function is useful when you need to have the current date displayed on a workbook, regardless of when you open the workbook. It is also useful for calculating intervals.

DAX functions - TODAY and NOW both return the current date. However,

• TODAY returns the time as 12:00:00 always.
• NOW returns the time precisely.

Example

= YEAR (TODAY () – [JoiningDate]) – 1900 returns the number of years of service for each employee.