How to get the first day of last month & last day of last month using DAX measure

Anonymous — Sun, 25 Jun 2023 02:25:01 GMT

Hello,

Can someone please guide how can we get the 'first day of last month' & 'last day of last month' using DAX measure.

Thanks.

Re: How to get the first day of last month & last day of last month using DAX measure

tackytechtom — Sun, 25 Jun 2023 04:12:15 GMT

Hi Anonymous ,

Maybe something like this?

Last day of last month:

Measure = 
EOMONTH(TODAY(), -1)

First day of last month:

Measure = 
EOMONTH(TODAY(), -2) + 1

Let me know, if this helps 🙂