STARTOFMONTH

The STARTOFMONTH function returns the first day of the month in the current context (or the first day of the first month, if the current context includes more than one) for the specified date column.

Syntax

STARTOFMONTH(
    dates
)

Parameters
  • dates: Column containing dates.
Returned value

The STARTOFMONTH function returns a table with a single column and a single row with a date.

Additional Information

The dates argument can be a reference to a column containing dates, an expression that returns a table with a single column containing dates, or a Boolean expression that defines a table with a single column containing dates.

Examples

The beginning and end of the month, the quarter and the year are shown in the following table for some dates of May 2011:

STARTOF and ENDOF functions

If we take the number of the month to the row headings in a matrix, the year to the column headings, and the following measure:

First day of the month = STARTOFMONTH(DimDate[Datekey])

...to the values field, we get the following result:

STARTOFMONTH function. Example of use

It can be seen how the result of the measure coincides with the first day of each month.

If, in the same scenario as in the previous example, we take the quarter to the row headers, the result obtained is the following:

STARTOFMONTH function. Example of use

We see how, in this case, the created measure returns the first day of the first month of the context.

Finally, if we take the week number to the row header, the result is the following:

STARTOFMONTH function. Example of use

In this case, the measure returns the first day of the month involved in the context. That is, even if the week in question goes, for example, from January 5 to 12, the STARTOFMONTH function will return January 1 for that context.

Category
Time intelligence
Submitted by admin on Tue, 12/04/2018 - 11:52