Forum Discussion
Merge a row with the previous one
Hi Anonymous,
Another way (if the null for key 2 and 3 are necessary to be kept) is to use some other string (or value) that is not in the dataset as a marker instead of null when replacing the TITLE1 and TITLE2 for example 'ZZZZZ'.
Then you can fill down on the UniqueKey column.
Then you can filter out the marker text from the Table1 and Table2 columns.
Community ChampionImkeF may have some thoughts on this but the way to reference another row in Power Query goes something like this:
=if [Index] = 0 then fnSierpinskiInit("0,1") else fnSierpinskiInit(#"Renamed Columns"{[Index]-1}[Sierpinski])
Red highlighting of the important part. This is from my article here: https://www.linkedin.com/pulse/fun-graphing-power-bi-part-sqrtpowersqrt82-deckler-microsoft-mvp-/
- ImkeF
In this case, "Fill up" will do: check your columns (except the KeyCol) -> right click your mouse -> Fill -> Up
