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

[vishu263]

Hello,

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

Thanks.

[tackytechtom · Accepted solution]

Hi @vishu263 ,

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 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/