Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
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.
Pete
Proud to be a Datanaut!
That did it! my friend.
Thank you
Cool, glad that's worked for you.
Have a nice weekend 👍
Pete
Proud to be a Datanaut!