Combining tables to get uniqe values

[patrickbender]

Hi,

I have two tables.

Table 1:

A

B

C

Table 2:

1

2

3

I would like to combine them into:

A1

A2

A3

B1

B2

B3

C1

C2

C3

Tried to work with generateseries and Generate but no luck so far. Hope to get some help here 🙂

[parry2k · Accepted solution]

@patrickbender add following dax expression to create new table, assuming table 1 has column name Id1 and table 2 has column name ID 2

New Table = ADDCOLUMNS ( CROSSJOIN ( Table1, Table2 ), "NewId", Table1[Id1] & Table2[Id2] )

Would appreciate Kudos 🙂 if my solution helped. Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com