Downloads
DAXTime intelligence: first and lastIntermediate

STARTOFMONTH

Returns the first date of the month that contains the dates in the filter context, as a one-row table.

Syntax
STARTOFMONTH(<dates>)

Returns: A table with one date, used as a filter inside CALCULATE.

What it does

STARTOFMONTH returns the first day of the month in context as a single date. Inside CALCULATE, it limits the measure to that day. Finance teams use it to read a balance on the first day of the month, or to build a start-of-month reference date for a roll-forward or a period label. For a total from the start of the month up to the current day, use DATESMTD or TOTALMTD.

Syntax and arguments

Example

A payroll liability report shows the accrued payroll on the first day of each month, to compare it with the accrual booked at the prior month end.

Accrued Payroll (start of month) =
CALCULATE(
    SUM('Accruals'[Amount]),
    STARTOFMONTH('Calendar'[Date]),
    'Accruals'[AccrualType] = "Payroll"
)

In an October 2026 row, the filter is October 1, 2026. The result is the payroll accrual on that day, which should match the reversal of the prior month's accrual.

Example: a second, different use

The start of the month as a date label, for a monthly roll-forward table that needs a fixed reference date for each row.

Period Start = CALCULATE(MIN('Calendar'[Date]), STARTOFMONTH('Calendar'[Date]))

Things to watch

In business terms

STARTOFMONTH supports the opening balance on the first day of the month, the start-of-month check on accruals and the period boundaries in a monthly roll-forward. It helps a team see whether the balance at the start of the month agrees with the close.

Related functions

All DAX functions · View as Markdown · DAX fundamentals