Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Append numbers from one table to another table

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.

1 Reply