First day of current month but in the previous year

[Anonymous]

Hi,

Looking to calculate the first day of the current month but in the previous year in a dax measure. So if ran today it would give me 5/1/2020.

Thanks in advanced

[CNENFRNL]

Time intelligence functions and time functions are totoally different,

[OwenAuger · Accepted solution]

Hi @Anonymous 

If you have a 'Date' table and you're wanting to create a date filter, you can write this:

SAMEPERIODLASTYEAR ( STARTOFMONTH ( TREATAS ( { TODAY () }, 'Date'[Date] ) ) )

 If you instead need the date as a scalar, you could write something like this:

EOMONTH ( TODAY(), -13 ) + 1

Regards,

Owen

[Anonymous]

Thank you! Just what I needed as I needed the date as a scalar.