QUARTER

The QUARTER function returns the quarter of a date as an integer in the range 1-4.

Syntax

QUARTER(
    date
)

Parameters
  • date: Value corresponding to a date in datetime format, or text representing a date.
Returned value

The QUARTER function returns an integer in the range 1-4.

Examples

In this first example we apply the function to obtain the quarter to which the date of March 31, 2020 belongs, for which we create the following measure:

Trimestre = QUARTER("31/3/2020")

Función QUARTER

We see that it returns the value 1 corresponding to the first quarter of the year.

In this second example, we start from a sales table that includes the Order Date field containing purchase dates, and we create a calculated column that extracts the quarter of each date:

Quarter = QUARTER(Sales[Order Date])

If we take the original date and the created field to a table, the result is the following:

Función QUARTER
Related functions
Category
Date and time
Submitted by admin on Thu, 01/02/2020 - 13:14