Append numbers from one table to another table

[Surabhi1711]

I need to append two columns from two separate tables into one new calculated column using DAX

Example:

Table1:

Table2 (with records starting from 1 to 24)

I need to append the value of 01 till 24 to each record of the Table1,

the Calculated Column should look like below:

2010070501

2010070502

and so on till 2010070524

and then 2010070601 and so on till 2010070524

and so on for other records.

[v-luwang-msft · Accepted solution]

Hi @Surabhi1711 ,

You need to use crossjoin to create a new table base on the two table , refer:

TableC = CROSSJOIN(TableA,SELECTCOLUMNS(TableB,"column2",RIGHT(TableB[Column2],2)))

Column3 = TableC[DateID]&""&TableC[column2]

Best Regards

Lucien