I’m glad you’re finding the Events in Progress pattern helpful. Regarding your question #1, ensure you’re using a [Dates] table with a [Month Ending] column like eDNA’s Extended Date Table.
if you then use a visual with the month ending date, you can use the Events in Progress pattern without modification.
I don’t have any immediate thoughts on your 2nd question, but will think on it a bit.