Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 3 tables,
Each has different columns and rows.
But both three 3 tables have column name "X" with value
Now I want to have a new column that includes full information of column "X" of three tables and remove duplicate values.
Could you please advise?
Solved! Go to Solution.
Hi @Annie2310 ,
You could a new table like this:-
Table_new =
DISTINCT (
UNION (
VALUES ( 'Table'[X] ),
VALUES ( 'Table (2)'[X] ),
VALUES ( 'Table (3)'[X] )
)
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Annie2310 ,
You could a new table like this:-
Table_new =
DISTINCT (
UNION (
VALUES ( 'Table'[X] ),
VALUES ( 'Table (2)'[X] ),
VALUES ( 'Table (3)'[X] )
)
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |