Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have two tables: PREVIOUS and CURRENT
I need to make this visualisation:
How do I put those two tables PREVIOUS and CURRENT together (if necessary) and how do I make this visualisation?
Thanks,
R.W.
Solved! Go to Solution.
Thanks Dobregon for your reply.
The two tables are imported from two Excel files
I solved the problem in the end using a DAX expression
COMPARE = UNION(CURRENT;PREVIOUS)
R.W.
Hi,
I have 2 options to you.
SELECT ID, CODE, YEAR FROM PREVIOUS UNION SELECT ID, CODE, YEAR FROM CURRENTThen you will have everthing in the same "table". Then you need to take a visual of columns
Hope this help you
Thanks Dobregon for your reply.
The two tables are imported from two Excel files
I solved the problem in the end using a DAX expression
COMPARE = UNION(CURRENT;PREVIOUS)
R.W.
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |