Forum Discussion

Juampi's avatar
Juampi
Regular Visitor
5 years ago
Solved

Create new table combining data from other tables

Hello ! 

 

I am new using power bi so i am sorry if this is a basic question. Tried to search similar questions but couldnt find an answer.

 

I want to create a new table (Table 3. Result) combining data from two other tables (Table 1 and 2) in the following way:

 

Table 1:

IDDescription
1A
2B
3C

 

Table 2:

Attribute 
XX
YY
ZZ

 

Table 3. Result

IDDescriptionAttribute
1AXX
1AYY
1AZZ
2BXX
2BYY
2BZZ
3CXX
3CYY
3CZZ

 

Thanks ! 🙂

 

Juampi