Display BLANK for values in a specific time frame based on second selected date

[joshua1990]

Hi experts!

I have a table like this that is not linked to a generic calendar table:

Dim 1	Dim 2	Date
1	B	01.02.2023
2	CD	05.03.2023
3	D	01.04.2023

Then I have a matrix that is built like this:

Dim	2023-Jan	2023-Feb	2023-Mar	2023-Apr
1		1	1	1
2				1

As you can see, if the Date in the column for the individual Dim, then there is a BLANK in the matrix.

How would you do that?

[lbendlin]

This depends on many factors. Are the tables linked? if so, from which end of the relationship did you take the fields?  If not, did you include measures?  Or maybe you have created a crossjoin?

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?