How to get value for Matrix from different table with blank values

[PeraZo]

Hello Power BI Community!

I am trying to create Matrix Table using value from different tables.

Below Picture is the Sales Record.

You can see that there are no sales for Product B in May.

Also there are no sales for all Products for June.

So these numbers should be blank in matrix.

Below is what I want to do.

When I tried this by straight forward just using this Sales Record Table, 

I dont see numbers for June.

Also this does not work when I have more transaction table, like Inventory Table etc.

So I made Product×Period (Cross Joined) master table and add columns to get sales number from the sales record.

※This way I can get numbers from other different tables like Inventory etc.

But I dont know the DAX or Query to accomplish this.

Is there any way I can do this??

Please help!!

And thank you very much for looking through and helping in advance.

[PeraZo]

Thank you. This is good solution I did not know there is function like this

[miTutorials · Accepted solution]

You will have to create a Calendar table and use the Month field from the Calendar table.

If you don't know how to create the calendar table, please see the below tutorial.

How to Create Calendar Table using DAX in PowerBI | MI Tutorials - YouTube

After that you need to click on the month field dropdown and choose 'Show items with no data'