DAX functions that return a single date

The first category of time intelligence functions that we are going to look at are those that return a single value. In reality, they return a single row of a single column table, so they can be used with any function that requires a table as a parameter.

The functions in this category are as follows:

  • FIRSTDATE and LASTDATE
  • FIRSTNONBLANK and LASTNONBLANK
  • STARTOFMONTH and ENDOFMONTH
  • STARTOFQUARTER and ENDOFQUARTER
  • STARTOFYEAR and ENDOFYEAR

Let's look at the first of these functions to help us understand how the functions in this category work.

The syntax of the FIRSTDATE function is as follows:

FIRSTDATE ( <Dates> )

The syntax of the LASTDATE functions is as follows:

LASTDATE ( <Dates> )

These functions ...

Get Hands-On Business Intelligence with DAX now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.