STARTOFMONTH
Returns the first date of the month that contains the dates in the filter context, as a one-row table.
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
- dates: the date column of the Calendar table. Required.
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
- STARTOFMONTH picks one day, the first day of the month. It does not total the month. Use TOTALMTD or DATESMTD for a total.
- The first day must have a row in any snapshot table, or the balance is blank.
- It uses calendar months. Fiscal months need a filter on fiscal columns.
- It is a filter helper. Put it inside CALCULATE, not as a stand-alone value.
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.