STARTOFYEAR DAX Function in Power BI
The STARTOFYEAR DAX function returns the first date of the year in the current context for the specified column of dates. A table containing a single column and single row with a date value.
DAX Syntax STARTOFYEAR(dates)
The function has the following parameters:
- dates: A column that contains dates.
- YearEndDate: It is an optional parameter. A year end date value.
Example: Let's create a measure with name "STARTOFYEAR Measure1".
DAX
STARTOFYEAR Measure1 = STARTOFYEAR('Students List'[Dates])
The output of the measure is shown below:
