Getting total value per day based on most recent status

I have two tables.

• A date table with a date column
• A table with data showing: StatusDateChange,UserId,NewState

For each date from the date column, I would like to count for each status group the count of users that fall in that status.

Basically what is the most recent status  up to each date of the row context.

For example, if someone was:

1. Awake on Jan 1st 2020
2. Asleep on Jan 3rd 2020
3. Sleepwalking on Jan 10 2020

I want my matrix to show case the following 

Obviously what i currently have when i activate the Show no data option from the date column

How do i fill in the gaps ? One important thing to note is that I don't want to cross join my table with every date possibility even though it would work since my table would generate over 100M rows by doing this.