Concatenating one column's value to the next row's another column's value

[nuibb]

Hi, I'm curious about concatenating different consecutive row's dissimilar column value into single one coulmn in Power BI. Suppose my table has two distinct column, column A and column B. column B has some null values. If any null values found in column B, then I want to add the column A's value to the previous row's column B value. How can I achive this in Power BI using either DAX or Power editor? Please help me out. Thanks.

[nickyvv · Accepted solution]

Hi @nuibb,

there is a solution based on this blog by @MattAllington. It uses 2 indices, merging the table by self-joining and a custom column to get the value you want.

Please have look at and let us know if that worked.