DATA MODEL CREATION - TWO DIFFERENT DATES

[Nycso94]

Hi All,

Thanks in advance for helping me with this issue that I am having.

Basically, I have this table:

INCOMING_DATE	CLOSING_DATE	UNIQUE_ID	CARDINALITY	CATEGORY
29/08/2023	29/08/2023	1	1	GAME
30/08/2023	30/09/2023	2	1	GAME
31/08/2023	30/10/2023	3	1	GAME
01/09/2023	31/10/2023	4	1	GAME
02/09/2023	01/11/2023	5	1	GAME
03/09/2023	02/11/2023	6	1	GAME
04/09/2023	03/11/2023	7	1	GAME
05/09/2023	04/11/2023	8	1	GAME
06/09/2023	05/11/2023	9	1	GAME
07/09/2023	06/11/2023	10	1	GAME

What I have issue is that I want to create a Matrix visualization in Power Bi with Column a general Date (that are used for both date columns) with the Sum of Cardinality.

I want to explain this better. I want only one date that filters the other two columns. So the result should be this:

I ask you help to handle that table in order to reach that matrix. I am in trouble to data modelling it.

Or just tell me that is not possible is fine. But how you handle this situation? Every time creating different visualizations for each date column?

Thanks for your help. I hope it is clear with the example

[Ahmedx · Accepted solution]

pls try this

[Nycso94]

Thanks! I need to study formulas that you used but it works!

Thank you so much!