DAX Date & Time - TODAY function


Advertisements

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.
dax_functions_date_time.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements