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 tables A and B.
How can I do?
Thank you!
8 Replies
tamerj1
thanks, it works!Hi Morgana_2022
distinct sum of what? Can you present sample of the the expected results?
I try to explain better...
I have a Table A
column "Competenze_Ruoli"
with values
1
2
2
3
1
3I have also a Table B
column "Competenze_Ruoli"
with values
1
1
2
3
3
2I must obtained a Table C
column "Competenze_Ruoli"
with values
1
2
3How do I get the Table C? What dax formula do I use?
Simply
Table C =
UNION (
VALUES ( 'Table A'[Competenze_Ruoli] ),
VALUES ( 'Table B'[Competenze_Ruoli] )
)
)
Hi!
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] )
)
)
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...
