Forum Discussion

PeraZo's avatar
PeraZo
Icon for Helper I rankHelper I
2 years ago
Solved

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

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.

2 Replies