Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Thanks! I need to study formulas that you used but it works!
Thank you so much!