One column with Startofyear from MAX date on dataset

[luisccmm]

Hi,

I want to Display one column with Startofyear on MAX date on dataset.

Lets say Max date on data set is "12 feb 2021", so year start for this date is "1st January 2021"

EXPECTED RESULT: a table with Year_month dimension and a Dax Measure [Yearstart_Max_date_dataset]  that shows yearstartdate from Maxdate on dataset.

Month                      [Yearstart_Max_date_dataset]

Feb -2021                1st January 2021

Jan-2021                  1st January 2021

.....

Jan-2019                  1st January 2021

.....

Jan-1999                  1st January 2021

I have tried STARTOFYEAR(LASTDATE(Date)) but it changes years value over year and I am not looking for that.

I need to use DAX function.

Regards

[amitchandak · Accepted solution]

@luisccmm , Try a measure like

measure =
var _max = maxx(allselected([Date]), 'Date'[Date])
return
eomonth(_max, month(_max)*-1) +1