Forum Discussion
Gozde
Helper I
Helper IAdd rows to table according to grouping in different table
Hi, I would like to add rows to one table ( or combine two tables) according to group number from another table. These are what I have: Table 1 Name Part A x1 B y1 B x1 ...
Zubair_Muhammad
Community Champion
Community Champion
GozdeHelper I
Helper IYes, definetely!
| Table 1 | |
| Name | Part |
| A | x1 |
| A | z1 |
| B | y1 |
| B | x1 |
| C | k1 |
| Table 2 | |
| Group | Part |
| 1 | x1 |
| 1 | x2 |
| 2 | y1 |
| 2 | y2 |
This is my expectation:
| Final Table | ||
| Name | Part | Group |
| A | x1 | 1 |
| A | x2 | 1 |
| B | y1 | 2 |
| B | y2 | 2 |
| B | x1 | 1 |
| B | x2 | 1 |
| A | z1 | |
| C | k1 |
Thank you again!
Regards,
Gozde
- Zubair_Muhammad
Try with this code
New Table = VAR Mytable1 = ADDCOLUMNS ( Table1, "My Group", CALCULATE ( FIRSTNONBLANK ( Table2[Group], 1 ) ) ) VAR JoinTables = ADDCOLUMNS ( GENERATEALL ( SELECTCOLUMNS ( mytable1, "Name", [Name], "My Group", [My Group], "My Part", [Part] ), FILTER ( Table2, Table2[Group] = [My Group] ) ), "Final Part", IF ( ISBLANK ( [Part] ), [My Part], [Part] ) ) RETURN SELECTCOLUMNS ( JoinTables, "Name", [Name], "Group", [Group], "Part", [Final Part] )- Zubair_Muhammad
- Gozde
Yes, changing generate to generateall solve the issue!
Thank you very much,
Gozde