Forum Discussion
Getting 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...
Table C =
DISTINCT (
UNION (
SUMMARIZE ( 'Table A', 'Table A'[Competenze_Ruoli], 'Table A'[Column] ),
SUMMARIZE ( 'Table B', 'Table B'[Competenze_Ruoli], 'Table B'[Column] )
)
)
tamerj1
no, I have to add the new column outside the DISTINCT.
The DISTINCT generates one, I have to add a second one in addition to the one generated by the DISTINCT...
It depends from which table, if you have relationships, based on which conditions.....