Forum Discussion
Add Column to Table1 from Table2.ColumnB for each value
Hi,
Not sure if title makes sense.
I have two tables
Table1 (Manually entered query): Only one column called 'names' with company names
Table2 (Calculated table with DAX expressions): Months, Years, Quarters and Concats of these combinations
I need to create a new table or add to Table1 where for each value in Table2.Year_Quarter, Table1.names duplicate
Example:
A - 2018 Q1
A - 2018 Q2
A - 2018 Q3
A - 2018 Q4
B - 2018 Q1
B - 2018 Q2
B - 2018 Q3
B - 2018 Q4
C - ETC ETC....
Thanks in advance
Hi RB1,
I made one sample for your reference.
1. Create a calculated column.
Table = CROSSJOIN(COMPANY,'DATE')
2. Create the calculated column in the calculated column.
Column = 'Table'[name] & " " & CONCATENATE('Table'[Year],'Table'[Q])Regards,
Frank
2 Replies
Hi RB1,
I made one sample for your reference.
1. Create a calculated column.
Table = CROSSJOIN(COMPANY,'DATE')
2. Create the calculated column in the calculated column.
Column = 'Table'[name] & " " & CONCATENATE('Table'[Year],'Table'[Q])Regards,
Frank
Hi RB1,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank