Forum Discussion
Solved
Referencing data from another row
I have a Table with the following structure Title Entry Data A 10 MasterData 1 A 23 SpecialData A 54 null B 10 MasterData 2 B 34 null B 576 null C 10 null ...
NewStep=Table.Combine(Table.Group(PreviousStepName,"Title",{"n",each Table.ReplaceValue(_,"","",(x,y,z)=>x??_{[Entry=10]}?[Data],{"Data"})})[n])
NewStep=Table.Combine(Table.Group(PreviousStepName,"Title",{"n",each Table.ReplaceValue(_,"","",(x,y,z)=>x??_{[Entry=10]}?[Data],{"Data"})})[n])
Thanks! This is working as I need it, I don´t understand it yet but I´ll go through it step by step till i do.
