Forum Discussion
Morgana_2022
Helper I
3 years agoGetting distinct values for multiple tables
HI! I have 2 tables: Table A and Table B. I have to create a new table C with the data "Competenze_Ruoli" obtained from the distinct sum (without duplicates) of the same data present in ta...
Morgana_2022
Helper I
3 years agoHi!
if I have to add a new column in addition to this one obtained with UNION, how do I write it?
Table C =
UNION (
VALUES ( 'Table A'[Competenze_Ruoli] ),
VALUES ( 'Table B'[Competenze_Ruoli] )
)
)