Date Calculation

[Niraj_vora0106]

Hi, community

I've created this DAX, For the getting dates for previous months. 

But when I'm doing m1-1, I'm not getting proper values. 

If I've selected Nov month then I should be getting 31st Oct 2021. But it's showing 30th Oct. Considering 30 days for each month.

Any solution for this.? Because I want the Previous month's last date that's why I did m1-1. 

And "selected-max-dates = MAX(Dates)" 

 

[amitchandak · Accepted solution]

@Niraj_vora0106 , a measure like

Last date of last month = eomonth(MAX(Dates[Date]), -1)

[Anonymous · Accepted solution]

Hi @Niraj_vora0106 

I think using EOMONTH() in your calculation will solve your problem. 

Here's the link to the documnation to help you in this:

EOMONTH function (DAX) - DAX | Microsoft Docs

[amitchandak · Accepted solution]

@Niraj_vora0106 , a measure like

Last date of last month = eomonth(MAX(Dates[Date]), -1)