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
     
parry2k's avatar
parry2k
Super User
4 years ago

Anonymous in future you should be very clear in your requirement so that it saves everyone's time. Just my 2 cents. Well done TheoC  but you don't have to do all that, you can just simply do this FYI

 

Measure = EOMONTH ( TODAY ()  , 0 )

 

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

TheoC's avatar
TheoC
Community Champion
4 years ago

parry2k I am in tears... I had forgot to add the 0 and couldn't understand why EOMONTH ( TODAY () ) wasn't working 😂 - cheers mate!