Replace Cell Value with the Cell above

[gtexeira]

Hi 

I am trying to use Power BI query editor to update certain values with the value in the cell right above.  Here is the table:

invoice    product

2000       tire

2001       rim

2003       winshield

2004       Part

2005       seat

2006       Part

When ever the product colum contains a cell with Part, I need the power BI editor to replace it with the cell right above.  So the product for invoice 2004 should become windshield and the product for invoice 2006 should become seat.

I tried = Table.ReplaceValue(#"Filtered Rows3","Part",each [invoice],Replacer.ReplaceText,{"product"}) but the replaces the cell with the value from the invoice coulmn.

Can someone please help me

[BA_Pete · Accepted solution]

Hi @gtexeira ,

Right-click on a cell that contains "Part" and, from the context menu, select 'Replace Values'.

Type "null" (with no quotations) into the bottom field, like this:

Now, select your [product] column and go to the Transform tab > Fill (dropdown) > Down.

Pete

[gtexeira]

Thank you @BA_Pete

The above suggestion just replaces the Part with a null value.  It does not replace/change to the cell value above.

[BA_Pete]

Pete

[gtexeira]

That did it! my friend.

Thank you

[BA_Pete]

Cool, glad that's worked for you.

Have a nice weekend 👍

Pete