First Day of the Month and Current Year

[AMR80]

I need to find the first day of the month from the month an employee started, but use the current year. 

I'm trying to do this with a Measure in PBI desktop. 

I tried the below measure formula, but it doesn't recognize the "Month" portion of the formula: 

The [Start Date] field is a Date field: 

Here's the measure formula:

Personal Hours Reset Date = DATE(Year(TODAY()),'Employee Time Used - Hours'[Start Date],STARTOFMONTH('Employee Time Used - Hours'[Start Date])

[Anonymous · Accepted solution]

HI @AMR80 

 Try the below formula:

Start of Current year Month = DATE(

                                                          YEAR(TODAY()),

                                                          MONTH(MIN('Date Sample'[given_date])),

                                                          1)

Thanks
Raj

[AMR80]

That did it @Anonymous !! Thank you very much

[Anonymous]

Hell0 @AMR80 ,

try with below measure,

Measure = DATE(YEAR(TODAY()),MONTH(MAX(Table[date])),DAY(STARTOFMONTH(Table[date])))

[AMR80]

That got me much closer thank you! The only issue now is the DAY. It returned 3/5/2021 instead of 3/1/2021. The actual Start Date in the Start Date field is 3/19/2018. Here is what your formula returned in PBI: 

[HotChilli]

You need to pass a number between 1 and 12 for the month parameter. You're trying to pass a date there.

Also, a measure is evaluated in context so if using a field from the data it has to have an aggregation round it (MIN, MAX etc) .  So please be aware whent constructing the measure.

[AMR80]

Thank you @HotChilli but I still cannot get it to work. Can you suggest a measure formula that would take this date (for example): 3/9/2018 and return: 3/1/2021 (the first of the month from the original date and the current year).