Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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)
Proud to be a Super User!
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)
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |