PowerbI - Grouping data by dates and products, but include blank dates

[Jezmona]

Hi All, I can not seem to work out a solution to my problem so hoping you experts can help!

I have a data set with Sales Data from the last 2 years. I am trying to summarise the data into a format i can use to do statistcal analysis on (i.e. averages, P10, P90, etc). 

To set the data up right im trying to summarise in a date by Date, ProductID, and Quantity Sold. However this only picks up days i had a sale which throws out my statistics. 

So im wondering if i can create the same groups but include a 0 when there is no sales on a particular date. I tried using a Date table which works to get the blank dates, but then i couldnt break it down by product. 

Using Group i can get it working but cant show blank days

Using summarise i can get the blank days showing but cant work out how to also group by ProductId

Any ideas for me? 🙂