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 ChampionHi 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_MuhammadCommunity Champion
Community Champion
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
- 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