Forum Discussion
Solved
how to repeat column value in PowerQuery
Hi Gurus, I have two columns in PoweBI, I want to repeate category name and subcategoty name until there is a new value, I want to know how to get it done in Power Query. m...
Ah, sorry, I didn't look carefully enough at your image, got too excited about fill down! lol
This function only works on 'null' values, so you'll need to select the column, click 'Replace Values'
Then use fill down.
Hi AllisonKennedy ,
thanks for the reply, but it did do anythin to to get me the expected table as in the image.
amalrio ,
There can be few ways.One can be.
Make all Test as null . In power Query -> Right click on Column and Replace "Test" with: null
Then use Fill Down - > https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/
Replace remaining null with Test