Forum Discussion

gtexeira's avatar
gtexeira
Frequent Visitor
3 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       ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 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
3 years ago

That did it! my friend.

 

Thank you

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

 

Cool, glad that's worked for you.

Have a nice weekend 👍

 

Pete