Simple table with dynamic measures - is this possible?

Hi all, 

Just looking to create a table that looks like the below, but really struggling to get the formatting right. 

The table that I intend to build should look like this, with each empty cell being a calculate measure of sales. 

The two data inputs I have are a date spine table, where each row is a unique date going back to the last year, calling from a  SQL table. 

The other data input are essentially total sales, where each row is a unique sale in the business. I have established a relationship that is one to many between these two datasets, but now just struggling to get a table working in the specified format. 

This should be easy, but when I add in new measures, they all get added next to each other on the same row. 

Has anyone done anything like this before, this would have taken me 2 minutes in excel or SQL. 

Thanks!