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