Forum Discussion

gtexeira's avatar
gtexeira
Frequent Visitor
2 years ago
Solved

Replace Cell Value with the Cell above

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

Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    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

5 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

    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's avatar
      gtexeira
      Frequent Visitor
      2 years ago

      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.