Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Last day current month

I'm trying to write a measure that will let me know the last day of the current month:   Last Day of Month = ENDOFMONTH('Work Date'[Date])   But this didn't give me the last day of the current m...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anonymous 

     

    That makes a lot of sense.  Try this measure and hopefully it will give you the end of the current month:

     
    Measure = EOMONTH ( TODAY () , 0 )
    (updated thanks to parry2k to ensure no one uses the ridiculousness of my earlier "solution").
     
    This will give 28 Feb 2022.  You can adjust month by changing the 0 at the end accordingly.
     
    Hope this helps 🙂
     
    Theo
     
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you TheoC and parry2k , 

 

but I'm still gettign 2072. Its not an error this is pulling from a live connection and the date ranges is 1904-2072 so if I do Min it is showing January 1, 1904 and Max is showing December 31, 2072.  

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi Anonymous 

 

That makes a lot of sense.  Try this measure and hopefully it will give you the end of the current month:

 
Measure = EOMONTH ( TODAY () , 0 )
(updated thanks to parry2k to ensure no one uses the ridiculousness of my earlier "solution").
 
This will give 28 Feb 2022.  You can adjust month by changing the 0 at the end accordingly.
 
Hope this helps 🙂
 
Theo