Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

EndOfMonth DAX Function Issues

I made a column: ThisDate= TODAY() 


I then attempted to make the column: EOM= ENDOFMONTH(Table[ThisDate])


The results return the same date as TODAY().  Why won't it return the date of the last day of the current month?


Any help is appreciated. 

Super User IV
Super User IV

You want EOMONTH, not ENDOFMONTH. ENDOFMONTH returns the last day of the month in the current context of the date column specified, which in your case is always TODAY().


See EOMONTH here:


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Hi Bhmiller89,


According to your description, you need to get the last day of current month by using a DAX expression, right?


If that is the case, you can use the DAX below
LastDay = EOMONTH(today(),0)



Charlie Liao


ISn't EndOfMonth() then essentially MAX() run on a dates column?

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting
Not applicable

I have a Calendar Table that ranges from 10/15/2018 to 03/28/2019. I wanted to add "Month" as a second column to use as a "Label" for aggregation. I used:

Month= ENDOFMONTH('Calendar'[Date])



When I pull this on to the visual, it misbehaves. I know this function has a scope of Current Context and that is fine with me in this case. What I don't understand is why Labels are "Offset" by a month?


I tried to change it from:

Month= ENDOFMONTH('Calendar'[Date]) to Month= STARTOFMONTH('Calendar'[Date])

This did fix my Latest month, but it also moved the first month.


Furthermore, changing TYPE of X-Axis does fix the issue by changing the Label Format; however that's not something I like to have.


Any expert opinion what's going on here? or is it a known issue or bug? 

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors