<!-- https://learnsql.cpetoday.com/functions/dax/startofmonth -->
# STARTOFMONTH

Language: DAX
Category: Time intelligence: first and last
Syntax: STARTOFMONTH(<dates>)
Summary: Returns the first date of the month that contains the dates in the filter context, as a one-row table.
Returns: A table with one date, used as a filter inside CALCULATE.
Level: Intermediate
Related: ENDOFMONTH, STARTOFQUARTER, STARTOFYEAR, FIRSTDATE, DATESMTD

## 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.

```dax
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.

```dax
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.
