FullQuarter (PQL)

Returns a list of quarter members derived from the given date-time member.

  • Returned Output: List
  • Library: PQL \ Semantic \ Date-Time
  • Version: 2018.00.000
  • Compatibility: Pyramid Query Language (PQL) data sources

Syntax

FullQuarter( <Member> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The member needs to be an existing member from a date-time flagged attribute in the model.
  • For details on how to employ and use this function see the semantic calculation overview.
Different Function types
  • This function is similar the month to date (QTD) function, but it calculates the entire quarter range.

Examples

The full quarter using a date of 2016-02-05 produces a list of dates starting January 1 2019 - March 31 2016:

FullQuarter( [data].[dateKey].[1454630400000] )

The full quarter using a date of 2016-02-05, with a start day of the 10th, produces a list of dates starting January 10 2019 - March 31 2016:

FullQuarter( [data].[dateKey].[1454630400000] ,10 )