Forum Discussion

amalrio's avatar
amalrio
Helper V
5 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    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.

amalrio's avatar
amalrio
Helper V
5 years ago

Hi AllisonKennedy ,

 

thanks for the reply, but it did do anythin to to get me the expected table as in the image.

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

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.