Need to create a table from the existing tables and union the data

[Venkateswara_ra]

Hi All

I have 2 tables A and B need to create C table from the A and B

In A table i have 4 columns 

In B table i have 4 columns

To Create C Table Need distinct data from 2 columns in A table and distinct data 2 columns in B table and union the data. 

sample data 

Table A
EmpId	Date	service no	mobile
52	21/05/2020	1256	695845213
754	2/4/2020	5264	58964125
8569	11/2/2020	2563	5289654
8569	11/2/2020	2563	5289654
256	5/5/2020	8526	59641253

Table B
EmpId	Date	roll of	sal
201	21/05/2020	Null	5
555	2/4/2020	Null	6
777	11/2/2020	Null	4
777	11/2/2020	Null	5
25	5/5/2020	Null	2

Need to create Table C
EmpId	Date	DateKey	EmpID+DateKey
52	21/05/2020	21052020	5221052020
754	2/4/2020	242020	754242020
8569	11/2/2020	1122020	85691122020
256	5/5/2020	552020	256552020
201	21/05/2020	21052020	20121052020
555	2/4/2020	242020	555242020
777	11/2/2020	1122020	7771122020
25	5/5/2020	552020	25552020

Can anybody help me need to create SSAS tabularr model 

[ryan_mayu · Accepted solution]

@Venkateswara_ra 

you can try to use DAX to create a new table

Table C = 
VAR A=ADDCOLUMNS(SUMMARIZE('Table A','Table A'[EmpId ],'Table A'[Date ],"datekey",day('Table A'[Date ])&month('Table A'[Date ])&year('Table A'[Date ])),"empid+datekey",'Table A'[EmpId ]&[datekey])
VAR B=ADDCOLUMNS(SUMMARIZE('Table B','Table B'[EmpId ],'Table B'[Date ],"datekey",day('Table B'[Date ])&month('Table B'[Date ])&year('Table B'[Date ])),"empid+datekey",'Table B'[EmpId ]&[datekey])
return UNION(A,B)