FIRSTDATE
Returns the first date in the filter context, as a one-row table.
FIRSTDATE(<dates>)Returns: A table with one date, used as a filter inside CALCULATE.
What it does
FIRSTDATE finds the earliest date in the current filter context. Inside CALCULATE it pins a measure to that one day. Finance teams use it to read a balance on the first day of a period, such as the cash balance at the start of the month, or to label the start of a reporting window. It does not find the first transaction date, which is a different question (see the watch list).
Syntax and arguments
- dates: the date column of the Calendar table. Required.
Example
A cash report shows the bank balance on the first day of each month, so readers can see the opening position before any of the month's activity.
Cash Opening (1st day) =
CALCULATE(
SUM('Bank_Balances'[Balance]),
FIRSTDATE('Calendar'[Date])
)
In an October 2026 row, the measure returns the balance on October 1, 2026. If the balance table has no row for that day, the result is blank, so the snapshot table must include every day.
Example: a second, different use
The first posting date in the ledger for the current filter, such as one account or one customer. Here MIN reads the fact table directly, because FIRSTDATE reads the Calendar.
First Posting Date = CALCULATE(MIN('GL_Entries'[PostingDate]))
Things to watch
- FIRSTDATE returns the first date in the context, even if nothing happened that day. The first transaction date needs MIN on the fact table or FIRSTNONBLANK.
- Use it with a Calendar column. Using the date column of a fact table gives a different meaning.
- Inside a month row, the result is the first day of that month. Inside a year row, it is the first day of the year that is in the context. Check both on a test visual.
- A balance read on the first day is the opening position. It equals the closing position of the day before, which is a useful check.
In business terms
FIRSTDATE supports opening balance reads, the start of a reporting window, and the first-day cash position used in the daily treasury report. For "when did this start?" questions, such as the first invoice or the first posting, MIN or FIRSTNONBLANK is the better choice.