Forum Discussion
New column with values from another table
Hello.
I have a table (Table A) with different columns which has a date column and I need another column (LT) with values from another table (Table B).
Table A:
| Date | Week |
| 06/02/2023 | 202306 |
| 13/03/2023 | 202311 |
Table B:
| NUM | DESC |
| 001 | a |
| 002 | b |
| 003 | c |
Final table A:
| Date | Week | LT |
| 06/02/2023 | 202306 | 001 |
| 06/02/2023 | 202306 | 002 |
| 06/02/2023 | 202306 | 003 |
| 13/03/2023 | 202311 | 001 |
| 13/03/2023 | 202311 | 002 |
| 13/03/2023 | 202311 | 003 |
Thank you.
3 Replies
Hello Maider ,
You can use 'CROSSJOIN' DAX to create this. New table calculation looks as below:
Combined Table = CROSSJOIN('Table 1','Table 2')Output looks as below:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thank you but I do not want another table. I want to add a new column to table A with values from column LT from table B. Is it possible?
In a table visual you can achieve it. But not in the data view of the table. Drag columns in table visual you will automatically see data like that.
