Add Column to Table1 from Table2.ColumnB for each value

[RB1]

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

[v-frfei-msft · Accepted solution]

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

[v-frfei-msft]

Hi @RB1,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank