Forum Discussion
Solved
Append Repeated Values to Multiple Item Rows
I have two separate, non-related, tables. I want to add all the data from one table to each item on the other table. Table 1: Item B627 B630 B642 B643 B646 B647 BA04 BA14 BA15 Tab...
M code
NewStep=#table(Table.ColumnNames(Table1)&Table.ColumnNames(Table2),List.TransformMany(Table.ToRows(Table1),each Table.ToRows(Table2),(x,y)=>x&y))
DAX
NewTable=GENERATE(Table1,Table2)
wdx223_Daniel
Community Champion
Community ChampionM code
NewStep=#table(Table.ColumnNames(Table1)&Table.ColumnNames(Table2),List.TransformMany(Table.ToRows(Table1),each Table.ToRows(Table2),(x,y)=>x&y))
DAX
NewTable=GENERATE(Table1,Table2)