Forum Discussion
Niraj_vora0106
4 years agoHelper III
Date Calculation
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)"
- Anonymous4 years ago
I think using EOMONTH() in your calculation will solve your problem.
Here's the link to the documnation to help you in this:
2 Replies
- amitchandakSuper User
- AnonymousNot applicable
I think using EOMONTH() in your calculation will solve your problem.
Here's the link to the documnation to help you in this: