COLUMN.DATE

Extracts the date associated with a measure or column header for use in calculations.

The COLUMN.DATE() function returns the date derived from the date dimensions in a measure or column header. It retrieves the date based on the column’s date hierarchy, such as year, quarter or month.

Example

1. Extract date from column hierarchy

We want to create a new measure that displays the date derived from the column header's date hierarchy.

Applying COLUMN.DATE()

2. Extract date from custom title

If user enters a date in the measure/column header's Title, COLUMN.DATE() returns that date from the title overriding the date derived from the column’s date dimensions.

Applying COLUMN.DATE()