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 IThanks 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
- Zubair_Muhammad
- Gozde
Yes, 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] )