How get data from row above

[Frixel]

hello,

How do I get the data from the line above into the 'article number' column?

 

like this

[Anonymous]

Thanks for the reply from bhanu_gautam, please allow me to provide another insight.

Hi @Frixel ,

Select the 'Artikelnummer' column, in the 'Transform' tab, select 'Fill', then select 'Down'

The final result is as follows. Hopefully it will meet your needs.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Frixel]

Thanks @Anonymous 

The reason it didn't work for me was because there were empty lines. I filled the empty lines with 'null' and then the Fill down worked

[Anonymous]

Hi @Frixel ,

It looks like your problem has been solved, please mark the helpful reply and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .
Thank you very much for your kind cooperation!

Best Regards,
Dengliang Li

[bhanu_gautam · Accepted solution]

@Frixel Try using

In the Power Query Editor, go to the "Add Column" tab.
Click on "Custom Column".
In the "Custom Column" dialog, you can use the following formula to shift the data from the line above into the 'article number' column:
m
= if Text.StartsWith([ColumnName], "Artikelnummer") then null else try #"Previous Row"[ColumnName] otherwise null

Replace ColumnName with the actual name of your column.

Fill Down the Values:

After creating the custom column, you need to fill down the values to propagate the 'article number' to the rows below.
Select the new custom column.
Go to the "Transform" tab.
Click on "Fill" > "Down".

[Frixel]

Thanks @bhanu_gautam 

What do you mean with the 'm' before the formule?

I get this error