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 |
| Table 2 | |
| Group | Part |
| 1 | x1 |
| 1 | x2 |
| 2 | y1 |
| 2 | y2 |
This is what I am looking for
| Final Table | ||
| Name | Part | Group |
| A | x1 | 1 |
| A | x2 | 1 |
| B | y1 | 2 |
| B | y2 | 2 |
| B | x1 | 1 |
| B | x2 | 1 |
I already tried merge/append or DAX code (Union or OuterJoin) and not succeed.
Do you have any recommendation? :)
Thank you!
Gozde
12 Replies
- Zubair_Muhammad
Community Champion
Hi Gozde
Please try this calculated table
New Table = VAR Mytable1 = ADDCOLUMNS ( Table1, "My Group", CALCULATE ( FIRSTNONBLANK ( Table2[Group], 1 ) ) ) VAR JoinTables = GENERATE ( SELECTCOLUMNS ( mytable1, "Name", [Name], "My Group", [My Group] ), FILTER ( Table2, Table2[Group] = [My Group] ) ) RETURN SELECTCOLUMNS ( JoinTables, "Name", [Name], "Group", [Group], "Part", [Part] )- Zubair_Muhammad
GozdeThanks for quick response. It helped me alot.
It is working in the example code. But, not in my real big data, becauase I have some parts in Table 1 which are missing in Table 2 (not have the group). How can I keep these parts? What should I change in code?
Thank you :)
Gozde