Populate Last Day of Month or Last Day of Week

Hello! I have a widget in a dashboard that shows the number of subscribers for my app week over week and year over year.  My data's grain is daily per subscription plan per platform.  For example, i...