topic Re: First day of current month but in the previous year in DAX Commands and Tips

First day of current month but in the previous year

Anonymous — Fri, 28 May 2021 22:50:42 GMT

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

OwenAuger — Sat, 29 May 2021 00:04:34 GMT

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

CNENFRNL — Sat, 29 May 2021 12:08:40 GMT

Time intelligence functions and time functions are totoally different,

Anonymous — Mon, 31 May 2021 22:39:37 GMT

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