Count values for specific date or date range

Hi ryan_b_fiting ,

You can also use Power Query to generate a row of dates when an account has been active. For example, for account 123, each date from Jan 1 to 3 will have one row in the dataset. For those that are still active, you can set them to have the dates from admission  until today or whatever your end date is. Here's a sample pbix for your reference - https://drive.google.com/file/d/1BQ_bcod8EfBGCVbD8BeWPY_qrl5sqAXC/view?usp=sharing