FIRSTDATE DAX Function in Power BI

The FIRSTDATE DAX function returns a table containing a single column and single row with the first date in the current context for the specified column of dates.

DAX Syntax FIRSTDATE(date)

The parameter date is a column containing dates.

Example: We have one table named Sheet1.

FIRSTDATE dax function in Power BI

The following expression returns the first date in the current context.

DAX

Table = FIRSTDATE('Sheet1'[MyDates])
FIRSTDATE dax function in Power BI