Subject line pretty much says it all 🙂 Please post any follow-up questions that would be helpful
You need a dimension like Is End of Month Yes/No that you could filter on. You can either add such boolean field in your data model or have a calendar table connected to your model with this field ready