Downloads
DAXTime intelligence: first and lastIntermediate

FIRSTDATE

Returns the first date in the filter context, as a one-row table.

Syntax
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

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals